Searching for junk characters & spaces

  • Thread starter Thread starter Vinodexcel
  • Start date Start date
V

Vinodexcel

Hi,

I am working with a huge database which needs to be cleaned an
standardized. Need to search for junk characters - #,* etc. and als
unnecessary (extra) spaces between 2 words.

Thank
 
Hi
simple way: use Edit - Replace for this. If you have to search for '*'
use '~*' for this task
 
Hi ...,
You might take a look at the comments related to TRIMALL macro
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

You can modify a version of the macro to remove/change
characters you do not want.

The Excel TRIM will remove the extra (duplicate) spaces,
the VBA TRIM will not touch the inside spaces between nonspace
characters. You can use either method within VBA.
 
Back
Top