Subscribe!

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

Related posts:

  1. Using Right() and Left() Functions to Remove Text from a String – Excel Today I came across a problem I see at least...
  2. Removing #N/A error in Excel using ISNA() The #N/A error happens most often when a lookup function...

This entry was posted on Wednesday, April 1st, 2009 at 9:30 pm and is filed under Excel Quick Tricks, Functions. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.