Hi Max,

Just try to figure out why the formula shows nothing (blank cell) when It
copied to another cells such as L1 or AA1 (it does not show any result)

Thanks

"Max" wrote:

Perhaps you could be having text instead of numbers in A1
(The A1 sample in your orig. post even had
spaces in between the digit "0" !)

Try this slight revision to Rowan's formula in B1,
copy across to J1 as befo

=IF(ISERROR(MID(SUBSTITUTE($A1," ","")+0,COLUMN()-1
+LEN(SUBSTITUTE($A1," ","")+0)-9,1)),"",
MID(SUBSTITUTE($A1," ","")+0,COLUMN()-1
+LEN(SUBSTITUTE($A1," ","")+0)-9,1))

And if required, just select B1:J1 and fill down to return correspondingly
if you have other values in A2, A3 ...
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Thomas" wrote in message
...
Rowan,

The A1 cell's value is 125000000, I tried with the suggested number and
still not showing any changes at all. Does the format of the cell must
also
be set into specific format such as number, text, general , etc as to make
the formula work ?

Thanks

Thomas