How can I remove spaces and other characters from my numbers in Excel?

Assuming that your numbers are all in one column, enter the following formula in a new column on the same row as your first number:

=SUBSTITUTE(A1," ","")

The first value in brackets is the cell containing the number to modify, the second value is the character(s) to substitute and the third value is what to substitute with.

Here, we are removing spaces from numbers. So, for example, 447624 808182 in A1 would become 447624808182 in B1, assuming that's the cell where the formula was entered.

The bottom right hand corner of cell B1 can then be dragged downwards, replicating the formula and applying it to cells A2, A3, A4 etc.