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