On Wed, 1 Jun 2005 19:50:01 -0700, "Himu"
wrote:

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?

A2: = A1/1000000000000
A3: = mod(A1/100000000,10000)
A4: = mod(A1/10000,10000)
A5: = mod(A1,10000)

I'm _assuming_ Excel has enough precision to do this correctly. Test
it on a couple of cases.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"I feel a wave of morning sickness coming on, and I want to
be standing on your mother's grave when it hits."