13
2
I have a column of number with white spaces in them. Like this: "32 445 423
". How do I get rid of all the white space to get excel to treat it as numbers rather than strings?
EDIT: Let me fill in some additional information that has come to light. My goal is to turn "32 445 423
" into a 32445423. If I write in the string "32 445 423
" into excel and use =SUBSTITUTE(A1;" ";"")
it removes the spaces just fine. But the numbers I have are imported from a csv file. When running SUBSTITUTE
on the imported numbers only leading and trailing spaces are removed.
1hey, do you want to split that string in 3 numbers or just to threat this as one number (in that case, " " is like a number separator of each x1000)? – kokbira – 2011-07-08T13:19:24.663