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.