On Sayfa2 try the following modifications of Bo_Ry's formulas:
1. E2 and down:
Formula:
=IF(LEN(D2)>10,--MID(D2,FIND("(",D2)+1,FIND("/",SUBSTITUTE(D2,":","/",2))-(FIND("(",D2)+1)),"")
2. F2 and down:
Formula:
=IF(LEN(D2)>10,--MID(D2,FIND("/",SUBSTITUTE(D2,":","/",2))+1,FIND("/",SUBSTITUTE(D2,",","/"))-(FIND("/",SUBSTITUTE(D2,":","/",2))+1)),"")
3. J2 and down:
Formula:
=IFERROR(--MID(D2,FIND("/",SUBSTITUTE(D2,",","/"))+1,FIND("/",SUBSTITUTE(D2,":","/",3))-(FIND("/",SUBSTITUTE(D2,",","/"))+1))+E2,--LEFT(D2,FIND(":",D2)-1))
4. K2 and down:
Formula:
=IF(LEN(D2)>10,--MID(D2,FIND("/",SUBSTITUTE(D2,":","/",3))+1,IF(LEN(D2)-LEN(SUBSTITUTE(D2,",",""))=1,FIND(")",D2),FIND("/",SUBSTITUTE(D2,",","/",2)))-(FIND("/",SUBSTITUTE(D2,":","/",3))+1))+F2,IF(LEN(D2)>3,--MID(D2,FIND("/",SUBSTITUTE(D2,":","/",2))+1,LEN(D2)-(FIND("/",SUBSTITUTE(D2,":","/",2))+1)),--RIGHT(D2,LEN(D2)-(FIND(":",D2)))))
Let us know if you have any questions.
Bookmarks