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?