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 ...
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