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.