substring

[Satyanaidu]

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

 

[MS-Exl-Learner]

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.

 

[Stefi]

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: