Hi,

If you really need a single formula for this, then try the following.
Paste you data into, say, A1, so that it looks like 1,2,3,4,5,6,7,8 etc.
Then enter the following formula in A2

=--MID(SUBSTITUTE($A$1,",",""),ROW()-ROW($A$1),1)

and copy down as far as necessary.

Dave

url:http://www.ureader.com/msg/104241285.aspx