CONCATENATE number and text from different cells

[Guest]

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

 

[T. Valko]

Works ok for me.

B1 = a number
D1 = some text

='C:\TV\[file.xls]Sheet1'!$B$1&" "&'C:\TV\[file.xls]Sheet1'!$D$1

=CONCATENATE('C:\TV\[file.xls]Sheet1'!$B$1,"
",'C:\TV\[file.xls]Sheet1'!$D$1)

Biff

 

[Guest]

T,
I tried the c:\ path and got the same result as before.
BUT...
=CONCATENATE(TEXT('[WORK ORDER.xls]COVER'!$B$19,"General")," ",'[WORK
ORDER.xls]COVER'!$D$19)
I found the TEXT operator and the number to text format qualifier"General"
or I assume "Text" and that seems to fix my problem, 3 hours, persistance,
later...

Thanks for your assitance.
furnaceman

Works ok for me.

B1 = a number
D1 = some text

='C:\TV\[file.xls]Sheet1'!$B$1&" "&'C:\TV\[file.xls]Sheet1'!$D$1

=CONCATENATE('C:\TV\[file.xls]Sheet1'!$B$1,"
",'C:\TV\[file.xls]Sheet1'!$D$1)

Biff

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