Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combining text and numbers in a string
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combining text and numbers in a string
Does the existing workbook use other separators? Look at the formulas, maybe a semicolon is used instead of a comma.
You can use ToolsOptionsInternational tab to change the settings. -- Kind regards, Niek Otten Microsoft MVP - Excel "ajd" wrote in message ... |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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combining text and numbers in a string
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? "Niek Otten" wrote: Does the existing workbook use other separators? Look at the formulas, maybe a semicolon is used instead of a comma. You can use ToolsOptionsInternational tab to change the settings. -- Kind regards, Niek Otten Microsoft MVP - Excel "ajd" wrote in message ... |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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find $ in a string of text and return numbers | Excel Discussion (Misc queries) | |||
Converting Text String to Separate Numbers | Excel Discussion (Misc queries) | |||
Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
Help - Separating numbers appearing on the right of a text string | Excel Worksheet Functions | |||
EXTRACT NUMBERS FROM TEXT STRING | Excel Worksheet Functions |