| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace text with formula
I have a column of formulas in text format, like this:
'=$F92-$F$89 with an apostrophe before the equal sign. I want to convert these to real formulas by removing the apostrophe. Unfortunately, when I do a find/replace of '= with =, Excel tells me it can't find it; same with replacing ' with null string. Does anyone know how to convert such strings to formulas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I replace a ' at the beginning of a text cell using Replace | Excel Discussion (Misc queries) | |||
| How do I replace text within a formula with a diff cell value? | Excel Worksheet Functions | |||
| How do I replace my vlookup FORMULA with just the TEXT of results | Excel Worksheet Functions | |||
| find text in cell and replace it with part of the text in that ce. | Excel Discussion (Misc queries) | |||
| How do I change replace text in a cell for different text? | Excel Worksheet Functions | |||
Threaded Mode
