| 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. |
| 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 | |||
Threaded Mode
