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 | =18+10 | =11+12 | =25+8 | =16+19 | =2+1 |
| =2+9 | =9+9 | =5+3 | =9+8 | =6+19 | =9+7 | =12+12 | =4+1 |
| =12+10 | =2+10 | =9+7 | =2+3 | =1+12 | =07+10 | =7+8 | =6+3 |
| =2+7 | =2+8 | =6+2 | =4+5 | =1+3 | =1+6 | =1+30 | =9+6 |
| =2+65 | =2+65 | =1+8 | =16+10 | =1+3 | =6+6 | =17+12 | =9+5 |
Regards,
Rajiv
10 Replies
I was able to copy the data, paste in Notepad, then copy from Notepad, and paste back into excel and it resolves your issue.
- 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
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
Select the data table, Find and replace " ' " with Blanks
send me your file to
ranjith.kgupta@gmail.com
Greetings!
Data Tools->Text to column->Others-> "'"->Column Data Format(General) works , but each column needs to be selected , doesn't work selecting the complete range i.e. F4:L9 as in the attached example sheet.
Thanks,
