Tim wrote...
Tried the replace function with no luck, it replaces the
space at the end of the number oand not at the
beginning. The only thing that seems to work is to
maually remove the space in the formula bar.
....

In that case these are almost certainly nonbreaking spaces (decimal
character code 160) rather than normal/ASCII spaces (decimal character
code 32). Instead of typing a space in the 'Find what' entry, clear
that entry, then hold down the [Alt] key and on the number keypad type
in sequence 0, 1, 6, 0 and release the [Alt] key. That should enter a
character that looks like a space. Then replace all with nothing.