Remove ' at beginning of cell
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
|