"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
--