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