| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
concatenate within an excel formula
It does sound like the cell where you input the formula was earlier
pre-formatted as TEXT (unknown to you of course), that's why. Re-format that cell as general/number (via FormatCells), then re-confirm the formula by clicking inside the formula bar and pressing ENTER. You need to re-confirm the formula to wake Excel up. Just re-formatting the cell alone will NOT trigger it. Success? hit the YES below -- Max Singapore --- "sarah - northampton" wrote: I am trying to concatenate cells and have the result execute within a formula. I am ending up with: =sheet4!A2 instead of the value that is contained in that location. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with the CONCATENATE formula | Excel Discussion (Misc queries) | |||
| How do I insert a hard return in a =CONCATENATE formula in excel | Excel Worksheet Functions | |||
| Excel Formula to concatenate record from 2 tables | Excel Worksheet Functions | |||
| help with formula...if -- concatenate | Excel Discussion (Misc queries) | |||
| Evaluating results of a concatenate formula, as a formula | Excel Worksheet Functions | |||
Hybrid Mode
