combining text and numbers in a string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to join a text string and a number into another text string.
When I open a new excel document and type in =CONCATENATE("t",3) for example,
it properly returns "t3". I have an existing workbook though which has
numerous spreadsheets and equations, etc already setup, for which I type the
same formula in a blank cell and it returns the #VALUE error. The format on
the cell is General and everything seems to be the same between the existing
workbook and the new workbook, but the equations respond differently. Does
anyone know what is causing this #VALUE error, and what I can do to fix it in
the existing sheet? Thanks.
 
Does the existing workbook use other separators? Look at the formulas, maybe a semicolon is used instead of a comma.
You can use Tools>Options>International tab to change the settings.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am trying to join a text string and a number into another text string.
| When I open a new excel document and type in =CONCATENATE("t",3) for example,
| it properly returns "t3". I have an existing workbook though which has
| numerous spreadsheets and equations, etc already setup, for which I type the
| same formula in a blank cell and it returns the #VALUE error. The format on
| the cell is General and everything seems to be the same between the existing
| workbook and the new workbook, but the equations respond differently. Does
| anyone know what is causing this #VALUE error, and what I can do to fix it in
| the existing sheet? Thanks.
 
That's apparently not the issue. The settings on that tab are the same.
There are a lot of functioning formulas on that page, the only one that acts
funny or doesn't work is the concatenate of a text and a number. Any other
ideas?
 
Back
Top