I'm trying to create a macro to format a lot of data for a person who's not
very sophisticated with Excel.
I've followed one of the suggestions on this post using msgbox
asc(left(A5,1)) to find out that what appears to be "spaces" are not actually
spaces but is chr(65). The earlier post also said that chr(160) is common.
My question is:
How do I detect what chr it is so that I can remove it. The Replace
functions works to remove the chr only if I can identify what the characters
are.
Thanks in advance