Remove apostrophe with Text to Columns Wizard
Most of the time, you’ll need to remove apostrophes while keeping the data in the same column.
To remove leading apostrophes in numbers, you cannot use the Search and Replace tool🤔
The reason for this is that, while you can see the apostrophe in the formula bar, it is not part of the cell content.
A number’s leading apostrophe is just a prefix character.
In this case, you can make use of the Text to Columns tool😍
All of the numbers in the table below contain a leading apostrophe.
You can follow the below steps for that.
- Select numbers with leading apostrophes. In this example, you have to select cells B2 to B7.
Then, you will notice that leading apostrophes are removed from all the cells👏🏻