/ / How to delete special characters in excel

How to delete special characters in excel?

  • LinkBack URL
  • About LinkBacks
  • Thread Tools
    • Show Printable Version
    • Subscribe to this Thread…
  • Rate This Thread
    • Linear Mode
    • Switch to Hybrid Mode
    • Switch to Threaded Mode
  • Remove Special Characters

    A user had exported a .csv from our online db and when she opened the document in Excel 2007 it had the "question-mark-in-the-box" special character between each word (the place where a space would be) in most, but not all rows.

    My question is how to remove this special character from the entire document.

    Last edited by bkatzman; 04-13-2010 at 11:51 AM .

    Re: Remove Special Characters

    First find out what Character code it is.

    =Code(Mid(a1,4,1)) where A1 contains a sample string with that character at the 4th position.

    After you find out the code.

    Then go to Edit|Replace

    In the Find what box: Hold the ALT key down and enter a 0 (zero) and the code only using the numeric key pad.

    In the Replace With box: enter a space with the spacebar

    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.