Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing spaces at the end of numbers
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
removing all spaces | Excel Discussion (Misc queries) | |||
Removing spaces from columns | Excel Worksheet Functions | |||
Removing Spaces from string | Excel Worksheet Functions | |||
removing spaces | Excel Discussion (Misc queries) | |||
removing spaces between the numbers | Excel Discussion (Misc queries) |