| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel:Get concatenated text to be recognised as formula not text?
Hi,
I hope I've selected the right discussion group. I want to concatenate the values of a set of cells as a string, and then have Excel recognise the string as a formula. For example: A1: 4 A2: + A3: 4 A5: = A6: =A1&A2&A3 I want cell A6 to return the answer to 4 + 4, and not the string "4+4". Any ideas? (I'm using Excel 2003) Thanks Yvette |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a month to a quarter ...... | New Users to Excel | |||
| Conditional formatting based on text within a formula | Excel Worksheet Functions | |||
| Text entries behaving like numbers | Excel Discussion (Misc queries) | |||
| Invisable text in formula bar | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
Threaded Mode
