Remove ' at beginning of cell

[JB]

Hello,
I have spreadsheet in which I did some find and replace work on
formulas. To the find and replace I had to put a ‘ before the formula
making it text. This worked fine. I thought I could do a find and
replace on the ‘ but the the find feature won't find the ‘. I have
been doing - F2 key, home key, delete key, return key, to get back to
formula. I have many cells and this is becoming tedious. Is there a
way (an easy macro perhaps) to remove the ‘ in the cells?

Thanks.
JBE

 

[yusoon]

If all your fomulas are within a column, try this:

1. Highlight the column
2. Data -> Text to Column
3. Choose Delimited and Next
4. Click Other: then key in '
5. Click Finish

Hope this help