Removing spaces at the end of numbers

G

Guest

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.
 
G

Guest

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.
 
P

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need to add spaces to the beginning of my texts which are numbers 1
Removing spaces in cell 4
Adding Spaces to the end of a value 4
Spaces not being recognized be excel as spaces!! Help! 4
Spaces after . at end of sentences 10
How to set the number of spaces after the period at the end of asentence? 7
Help with blank cells when concatenating 11
Removing rows with spaces at beginning of cell? 8

Top