Remove Leading Apostrophes in MS Excel with Example.

Remove Apostrophes (') starting in a word or number in MS Excel / Easily Remove Leading Apostrophes with Example in Microsoft Excel.

How to Remove Quickly leading apostrophes in MS Excel?

Sometimes when you import data from some other source into MS Excel, you may find that some of the values (either text or numbers) contain leading apostrophes. These apostrophes doesn't look out normally but when you edit the cell then it looks out. These apostrophes creates an issues when you reference those cells with various formulas such as VLOOKUP. 

Remove Apostrophes

You can't remove that apostrophe with the help of simple Find and Replace (Search and Replace), you think that it would work, but unfortunately, that won't work.

So here is a trick / way to remove leading apostrophes. 

The quickest way I know of to remove leading apostrophes is by using the Format Painter (Home tab, Clipboard group) to copy the format from a cell without an apostrophe (e.g. a blank cell) to all of the cells containing the apostrophes.

If any of these cells contain leading zeros and you want to keep them, you will need to format those cells as Text.