View Single Post
  #1   Report Post  
Nino
 
Posts: n/a
Default How do I remove leading apostrophes in Excel?

I have a large Excel spreadsheet made up of about 30,000 cells.

Most of them have a leading apostrophe (') in them, whether they are numbers
or text.

I would like to remove all the leading apostrophes without having to do it
manually, cell by cell.

Any ideas?