Archive for April, 2009

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