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?