Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CONCATENATE number and text from different cells
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CONCATENATE number and text from different cells
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 "furnaceman" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CONCATENATE number and text from different cells
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 "T. Valko" wrote: 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 "furnaceman" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
number of cells containing text | Excel Discussion (Misc queries) | |||
How to set a number number value as text in all cells ? | Excel Worksheet Functions | |||
Can I concatenate text in cells to make a working formula? | Excel Discussion (Misc queries) | |||
How to Concatenate with a text & number | Excel Worksheet Functions | |||
concatenate a text string if two different cells contain the sam. | Excel Worksheet Functions |