Check out "Text To Columns".

This will split your data into the columns you wish, without the necessity
of possibly having to eliminate parsing formulas.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Himu" wrote in message
...
Hi:

Suppose I have 16 numbers in a cell (A1), e.g. 1234567890123456. Now I
want
to spit the numbers in 4 parts for that I get the numbers 1234 in cell A2,
5678 in cell A3, 9012 in cell A3 and 3456 in cell A4.

Anyone have any idea how I can do this?

Thank you.

Himu.