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.
Re: Remove special characters from a column
I recommend using a UDF (User Defined Function) such as the one at...
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By gspreeman in forum Excel Programming / VBA / Macros
Last Post: 05-14-2014, 04:50 PM
By Latha Mani in forum Excel Formulas & Functions
Last Post: 01-13-2014, 07:14 AM
Last Post: 08-14-2013, 08:12 PM
By humacdeep in forum Excel General
Last Post: 01-14-2012, 03:36 PM
By bkatzman in forum Excel General
Last Post: 04-13-2010, 11:51 AM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1