remove all nonprinting whitespace characters

[Eric]

I imported some data from some Active Server pages in
Excel and there are some blank spaces or whitespace that
I can not delete. I can delete it manually, although,
there are 7 columns of 1080 rows. Help please. The trim
and Clean functions will not remove this.

 

[pfsardella]

David McRitchie has some info on this.

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

Chip Person's CellView add-in allows you to see the exact characters
in a cell, as well as their character codes (in either decimal or hex
numbers).

http://www.cpearson.com/excel/cellview.htm

HTH
Paul