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)


"Chris T." <Chris wrote in message
...
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.