+ Reply to Thread
Results 1 to 2 of 2

Remove special characters from a column

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    Remove special characters from a column

    I have column that is only allowed to contain letters, numbers, and spaces. Right now I'm doing several "find/replace" tasks to remove all the special characters (find a comma, replace with nothing; find a pound sign, replace with nothing, etc)...

    Is there a formula I can use to clean up the cell value of all special characters, leaving only letters, numbers and spaces? I've tried to google this and found some people using "trim" and "left" functions, but my characters are located at random places that vary from cell to cell, so that won't work for me.

  2. #2
    Valued Forum Contributor
    Join Date
    Ohio, USA
    MS-Off Ver
    Excel 2013

    Re: Remove special characters from a column

    I recommend using a UDF (User Defined Function) such as the one at...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need simple script to remove special characters in column A
    By gspreeman in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-14-2014, 04:50 PM
  2. [SOLVED] how remove all special characters except # , & - .
    By Latha Mani in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-13-2014, 07:14 AM
  3. [SOLVED] Remove ALL Special Characters
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-14-2013, 08:12 PM
  4. Remove special characters
    By humacdeep in forum Excel General
    Replies: 6
    Last Post: 01-14-2012, 03:36 PM
  5. Remove Special Characters
    By bkatzman in forum Excel General
    Replies: 10
    Last Post: 04-13-2010, 11:51 AM


Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1