Text to columns is the best way, but the following UDF will do the same thing:

Public Function items(r As Range, whichone As Integer)
ary = Split(r.Value, ",")
items = ary(whichone - 1)
End Function

So with your data in A1, enter:

=items(A1,1) =items(A1,2) =items(A1,3) =items(A1,4)

in some row
--
Gary''s Student - gsnu200804


"Hardworker" wrote:

hi,

is it possible to convert the contents of cells to rows eg. i have rows of
cells which contains numbers seperated by a comma (542212, 542213, 542214
etc).

Is there a way of doing this without using the text to column first?