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.