View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JB[_2_] JB[_2_] is offline
external usenet poster
 
Posts: 6
Default 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