Hi,

I have to separate the number (0101940195183000) into 4 parts. i.e
Part1 12
Part1 3019
Part 10718139
Part 1000

and need to paste in 4 separate columns. Please help me if there is any
formula...because i have to do this process for multiple numbers.

Thanks,
Satya

Hi,

Check your example data once again, because the separated numbers are not
matching with the bracket numbers i.e. (0101940195183000) is mismatching with
Part 1 to Part 4 Numbers.

--------------------
(MS-Exl-Learner)
--------------------



"Satyanaidu" wrote:

Hi,

I have to separate the number (0101940195183000) into 4 parts. i.e
Part1 12
Part1 3019
Part 10718139
Part 1000

and need to paste in 4 separate columns. Please help me if there is any
formula...because i have to do this process for multiple numbers.

Thanks,
Satya

Part1: =LEFT(A1,2)
Part2: =MID(A1,3,4)
Part3: =MID(A1,7,8)
Part4: =MID(A1,15,4)

But in your example the source string is 16 character long and you want to
extract 18 characters. Check your data!

Regards,
Stefi


€žMS-Exl-Learner€� ezt Ã*rta:

Hi,

Check your example data once again, because the separated numbers are not
matching with the bracket numbers i.e. (0101940195183000) is mismatching with
Part 1 to Part 4 Numbers.

--------------------
(MS-Exl-Learner)
--------------------



"Satyanaidu" wrote:

Hi,

I have to separate the number (0101940195183000) into 4 parts. i.e
Part1 12
Part1 3019
Part 10718139
Part 1000

and need to paste in 4 separate columns. Please help me if there is any
formula...because i have to do this process for multiple numbers.

Thanks,
Satya