If you are using data from the web there might be non space html characters
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
is a macro that will clean these
here's how to install macros
http://www.mvps.org/dmcritchie/excel...la.htm#install
--
Regards,
Peo Sjoblom
"Kim" wrote in message
...
I have thousands of rows of data that I have used the "Text to Columns"
function on so that they are now two columns instead of one (text in A,
numbers in B).
However, there are leading and trailing spaces in both columns, and when I
used the =TRIM function to remove them, it doesn't work. Even when I use
TRIM
in column D, then copy that value into Notepad, I can still see the
spaces.
What's wrong?
-- Thanks,
-Kim