David's excellent macro zaps extra spaces and non-breaking-spaces
CHAR(160), but doesn't remove any other characters, nor does it
remove single spaces between other characters.

Guess it depends on what the OP considers "special".



In article ,
"Ken Wright" wrote:

If you are talking about cleaning up data that has been imported from the
web,
then you might want to take a look at Dave McRitchie's Trimall macro which
will
zap that garbage but good!!

http://www.mvps.org/dmcritchie/excel/join.htm#trimall