Dear Max,

It works
Thank you very much indeed for your kindness help and time,
In addition, could you kindly advise for any references especially
book,websites, etc that it might help me to learn or mastering this kind of
matter.
It would be greatly appreciated for your advise and help

Regards,

Thomas


"Max" wrote:

"Thomas" wrote:
So how to make it work on the other cell then ?

Depending on where is your new source cell, and
where you want to decompose the digits,
the formula could be revised/adapted to suit ..

For example, if your "other" source cell is in say, K1,
and you want to decompose it within say, L1-T1

Put in L1, copy across 9 cols to T1:

=IF(ISERROR(MID(SUBSTITUTE($K1," ","")+0,COLUMNS($K$1:K1)
+LEN(SUBSTITUTE($K1," ","")+0)-9,1)),"",
MID(SUBSTITUTE($K1," ","")+0,COLUMNS($K$1:K1)
+LEN(SUBSTITUTE($K1," ","")+0)-9,1)+0)

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--