Is there a possibility for a formula solution?

Assuming source data in A1 down
Try in say, B1: =SUBSTITUTE(SUBSTITUTE(A1," ",""),",","")+0
Copy down
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"martin" wrote in message
...
Hello all!

When copying number from Navision account program to Excel, it copies
numbers with spaces as text, but not as numerical values.
Such value: 1 109 014,08 is copied as text.

One possibility to set the number actually to a numerical value is to
delete
the spaces within the number, so after doing that it looks as 1109014,08.
Then i can add, multiply, divide this number with ease.

Is there a automatic possibility how remove those spaces?
Is there an alterantive?