Concatenate adds 0

Originally Posted by daddylonglegs

Try this

=IF(L1="","",L1&" ")&M1

Thanks daddylonglegs,

Tried your formula but unfortunately with no success.

Hi Andy
I opened another workbook and copied and used paste special/values and was able to get the result I wanted.
Could it be to do with the source being on another page.
e.g. columns L shows "=box_identity!E1" & column M shows "=box_identity!F1" 9my quote marks)

The workbook is huge so I'm not sure what I could send.

Also I'm using excel 2003.