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 ...
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,
Any other way to do it faster ? Thanks