Forum Discussion
To remove " ' " from cell
Hello Experts , Could you please advise how to remove " ' " from cell in one go. Require answers for below Table. =2+3 =3+3 =7+1 =25+3 =25+9 =6+5 =12+18 =9+3 =2+5 =3+8 =8+9 ...
Dear Rajiv Kokitkar,
If your data is in cells A1 to H6, then in cell A8, enter the formula =" "&A1.
I have used space, you may use any other unique character that can be replaced with Find & Replace.
Drag (or Paste) the formula in A8 to H13.
Copy A8 to H13 and Paste special values in A8 to H13.
Paste this data into your original range (A1 to H6).
Find Space and replace with blank.
The Space before the = sign will get eliminated and the cell content will get converted to formulas.
There may be better methods to do this activity. I use this method
Do let me know if it solves your problem.
Vijaykumar Shetye,
Panaji, Goa, India