Hi,

I have around 300,000 cells (two colums by 150,000 rows) of text data that has an apostrophe leading each value. For example, I see the following:
  • John
  • Laura

Though when I look inside each cell I actually see the following:
  • 'John
  • 'Laura

I need to remove this leading apostrophe because it is messing up a formula that should reference these values and then perform a lookup in another table. How can remove these leading apostrophes? I've tried Find/Replace and RIGHT(A1,LEN(A1)-1) but these do not work. They do not recognize the apostrophe as part of the values in the cells.

Thanks a ton!!
John