Let's say you want the numbers in column B - put this in B1:

=IF(A1="","",IF(ISNUMBER(A1),A1,""))

and this in C1:

=IF(A1="","",IF(ISNUMBER(A1),"",A1))

then copy these two formulae down.

Hope this helps.

Pete

On Jan 16, 1:12*am, deb wrote:
I have this information in the same column:
ACER
146555
THOMAS
188223

There are some blank lines in between - I need all the text in one column
and all the numbers in another but I need them to stay on the same row they
are on - can anyone help with this?