How can you remove "spaces" between numbers in one cell? (ie 1 000 000) I
need to remove the space between the numbers over a large range of cells with
numbers in them with spaces.

I have tried trimming, cleaning the cells and defining them as numbers but
it seems like the only way to do this is by physically going into each cell
and deleting the space.

A shortcut in doing this would appreciated.

Thanks for all your help.