That's easily fixed

=MID($A$1,ROW(1:1)*4-3,4)

copy down and you'll get it

--
Regards,

Peo Sjoblom

(No private emails please)


"Himu" wrote in message
...
Peo:

the problem i am facing with using "MID" function is that, I have to
specify
the start start_num and num_chars. But I want somthing that will divide
the
numbers in the cell in 4 parts without having me to manually type the
start_num and num_chars.

My actual problem is that I have a number with 164 digits in one cell and
i
want to divide them into parts of 4 digits in each parts. I just simplied
my
question to a 16 digits number. Hope you understand why it is difficult
for
me to manually type the start_num and num_chars.


Thankx!

HIMU

"Peo Sjoblom" wrote:

Use mid

=MID(A1,1,4)

then

=MID(A1,5,4)

and so on

--
Regards,

Peo Sjoblom

(No private emails please)


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