Removing spaces at the end of numbers

[Chris T.]

I downloaded some online financial data to excel. One sheet is out of whack.
All numbers are registering as text (I used istext to check) and there are
two spaces at the end of each number (i.e. 477.5 )-notice 2 spaces before
the end parentheses. This keeps me from doing any formulas or calculations
with these cells (about 11 columns with 245 rows - thats why I don't want to
retype the data). How do I remove the two spaces? Is there a macro? Excel
function? I tried =LEFT(C14,FIND(" ",C14,1)), hoping to take the leftmost
values before the space, but no go. Any help would be greatly appreciated.

 

[Peo Sjoblom]

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


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

 

[DaveMoore]

You could also try > Data > Text to Columns

 

[David Biddulph]

=--TRIM(A1)

 

[Chris T.]

Thank you very much for the direction. The TrimAll macro was perfect. Thanks
also to all the others that responded - I didn't get around to trying your
options, but they probably are just as applicable.

 

[Peo Sjoblom]

Yes but it won't work if it is a trailing html character
which happens quite often with downloads


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)