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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace text with formula
If u could just record a macro for that.
Its easy & simple.. Boss "hmm" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace text with formula
Select the column of text formulas, then, from the menu bar:
<Data <Text To Columns <Finish And you're done! -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "hmm" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace text with formula
Highlight the cells with your "text formulas" in them and then select
Data/TextToColumns from Excel's menu bar. On the dialog box that appears, select the "Fixed width" option button and click on the number scale anywhere to the right of your longest line of text (in order to create a separating vertical line) and click Next; make sure that the "General" option button is selected for you column of text and click Finish. Your "text formulas" should now be real formulas. Rick "hmm" wrote in message ... 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? |
Reply |
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 |