Hi,
i'm using Excel 2003 on Windows xp srvc pk 2
When I try to join "concatenate" a number and a text cell, both formatted as
"general" or 'text" I get an error value unless I use an ampersand.
i.e. =A2,C2 returns error value
=A2&C2 returns 123Main St.
=CONCATENATE(B19," ",D19) returns 123 Main St.
the latter 2 work fine except..
When I'm working between workbooks.
I can join text OK between workbooks but not a number and text ...
returns error value
Any help would be appreciated
furnaceman