How can I remove hidden apostrophe in Excel? - JimMober

Hi,

I have a spreadsheet of data and a number of the columns have data that is
preceeded by a hidden apostrophe.  The apostrophe can only be seen when you
click on the cell.  I have looked and can't find a post that addresses this.
Can anyone out there tell me how to remove this.  I have tried using the trim
function in conjuction with the clean function and it didn't work.  Ack!