Remove the ‘ Apostrophe from Excel Cells
Posted on April 1st, 2009 by Joseph Harris
Many applications that export to Excel, export the data with the apostrophe character at the front of the string. One way of removing this character is to use the clean() function:
If in cell A1 you have: ‘output
Then in cell B1 type =clean(A1). The result will be: output
Joseph Harris
Excel Help
Bookmark It
