Getting Excel to interpret string as formula
March 29, 2008 11:39 AM Subscribe
Getting Excel to interpret text string as formula
posted by found missing to computers & internet (7 answers total) 1 user marked this as a favorite
I'm in MS Excel 2003. I created a column of formulas by concatenating strings from other cells, so in any given cell I now have a string that looks like this:
Note the apostrophe, b/c that is forcing Excel to interpret the cell as a text string rather than as a formula.
In older versions of Excel, I could simply globally replace = with =
Somehow, that wiped out the apostrophe. But, that doesn't work for me now.
Now, I'm stumped. Without opening each cell individually and deleting the damn apostrophe, I can't figure out how to get Excel to view these cells as formulas.
I tried to write a macro to do that, but I'm inept at macros.
Please hope me.