how do I remove spaces from cells that were pasted
 

I am pasting numbers into a spreadsheet, however its treating them as text
because there is a space before the number. How do I remove the space so it
treats it as a number ? I have used the =trim() function and its not working.
Thanks for any help !

Hi!

It sounds like you're copy/pasting from a website.

Try this macro from David McRitchie.

Look for TRIMALL, it's about half way down the page:

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

Biff

-----Original Message-----
I am pasting numbers into a spreadsheet, however its
treating them as text
because there is a space before the number. How do I
remove the space so it
treats it as a number ? I have used the =trim() function
and its not working.
Thanks for any help !
.