View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hmm hmm is offline
external usenet poster
 
Posts: 175
Default 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?