substring

  • Thread starter Thread starter Satyanaidu
  • Start date Start date
S

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
 
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.
 
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:
 
Back
Top