Searching for junk characters & spaces

[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

 

[Frank Kabel]

Hi
simple way: use Edit - Replace for this. If you have to search for '*'
use '~*' for this task

 

[David McRitchie]

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.