Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: How to remove special characters in excel

  1. #1
    Board Regular
    Join Date
    Jul 2008
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to remove special characters in excel

    I am looking for a formula to remove special characters (like ' , " & - ) in a sheet.
    Thank you.

  2. #2
    Board Regular
    mmmm Pizza
    Sandeep Warrier's Avatar
    Join Date
    Oct 2008
    Location
    Mumbai, India
    Posts
    2,672
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to remove special characters in excel

    The simplest way is to use Find/Replace (Ctrl+H)

    In the Find What area type in "," (without the quotes) and in the replace with area type in whatever you want to replace , with and click the button called Replace All.

    You'll have to use this multiple times, once for each character you want to replace)
    Regards,
    Sandeep


    You can post sample data using any one of the following ways:

    1. Richard Schollar's HTML Maker
    2. Excel Jeanie
    3. Border Copy Paste

    Use code tags [CODE]'Your Code[/CODE]
    for posting codes.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •