Hi,

As OssieMac pointed out the spaces may not be spacebars so using either a
formula or the Replace command may fail. If they don't work then try this:

Suppose the number is in cell A1
1 2 3 . 4 5
in B1 enter the formula
=CODE(MID(A1,2,1))
This will return the character code of the first space as a number such as
178.
In the substitute formula use
=SUBSTITUTE(A1,CHAR(178),"")
for the Replace command highlight the space in the cell and copy it (just
the space), choose the Edit, Replace command and click in the Find what box
and press Ctrl V. Leave the Replace with box empty and choose Replace All.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Chris" wrote:

Visa put SPACES between all the numbers. (e.g. 1 2 3 . 4 5 )


How do I get back to a 123.45?