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 ...
dont know how u done it but if you change its format by using FormatPainter and copy from A1 of your workbook to these formulas cells, will definitely remove " ' "
Hi S Akkaz H Jaffary,
If the apostrophe is removed only using format painter, then the data will still remain as text, and the formulas will not get evaluated.
instead of '=2+3, the cell will now display =2+3
If the required result is 5, then removing apostrophe by using format painter alone shall not serve the purpose.
Hi Vijay
in this case, after using FormatPainter, use "Find and Replace"
first replace "=" with any thing, lets do it with "-"
then "-" with "="
i checked this process with your attached file, its working and showing results
Regards
Akkaz