Split cells into the following columns

[aaaaa34]

Hey my friends,

I need your help to write formula to split/extract data in the given cells.
In the attached file sheet1, there are five matches in the list. From A to D column.
In second worksheet, you can see that desired result with the data in these cells is extracted into cells along the columns from F to O.

Here how it goes:
A column cell is extracted in terms of first "." in the cell. Left from the point into F, right from "." into G, if there is no "." in the cell like A3, it will be error.
B column cell is split into H and I in terms of date and hour.
C column cell, team names will be spllitted into columns J and K in terms of " - "
D coloun cell is score. The score out of the paranthesis is final score of the match, it will be N and O column. Halftime score is the first score before the comma "," in the paranthesis. If there is no paranthesis in the cell like D2, halftime score colums L and M, it will be error. If there is a score inside paranthesis, but there is no "," like D3, again it will be error.

Thanks for your interest guys. Waiting for your replys.

[Special-K]

B4 contains / already. This is different to the rest of your dates in column B.

Is column B a mixture of dates separated by . and / ???
Or is a this a typo?

[Bo_Ry]

Please try at
F2
=TRIM(LEFT(SUBSTITUTE(A2,".",REPT(" ",40)),40))

G2
=MID(SUBSTITUTE(A2,F2,),3,40)

H2
=IFERROR(INT(B2),--SUBSTITUTE(LEFT(B2,FIND(" ",B2)),".","/"))

I2
=IFERROR(--MID(D2,FIND("(",D2)+1,1),0)

[aaaaa34]

B4 contains / already. This is different to the rest of your dates in column B.
Is column B a mixture of dates separated by . and / ???
Or is a this a typo?

sorry for the confusion, it should be only "." , not any "/".
I made all B column format "Text" and updated attached file in post #1.
I have changed even filename because it looks like others in forum didn't like my thread title too.

[aaaaa34]

All formulas working properly in attached file, @Bo_Ry
I only wish that L2, L3, M2, M3 cells could stay empty like cells G4 and G6,
Halftime score is the first score before the comma inside paranthesis D2 doesnt have any score inside the paranthesis. D3 has a score inside the paranhesis but there is only one score inside it, no any score else seperated with a comma.

[Bo_Ry]

Please try at
L2
=IF(LEN(D2)>10,--MID(D2,FIND("(",D2)+1,1),"")

M2
=IF(LEN(D2)>10,--MID(D2,FIND("(",D2)+3,1),"")

[aaaaa34]

Half-time formula worked perfectly too @Bo_Ry , thank you so much
But I failed dealing with full time (90 mins) scores
Because league matches finish in 90 mins and they have only 1st half and 2nd half goals inside paranthesis such as 3:1 (0:1,3:0).
But, cup matches or qualifying matches can go for extra time (15mins X 2 half) and even penalties such as 5:4 (0:1,1:0,0:0,0:0,4:3)
So now I'm attaching new workbook to form fulltime score columns neglecting extra time or penalties scores, including existing halftime formula.
In this manner, 5:4 (0:1,1:0,0:0,0:0,4:3) shows that 90 mins of this game ended 1-1. so fulltime columns should be shaped like this.
Please have a check the file and desired result worksheet, you will understand it with examples.

[Bo_Ry]

Assume that score is one digit

H2
=IFERROR(MID(D2,FIND("(",D2)+1,1)+IFERROR(MID(D2,FIND(",",D2)+1,1),0),--LEFT(D2))

I2
=IFERROR(MID(D2,FIND("(",D2)+3,1)+IFERROR(MID(D2,FIND(",",D2)+3,1),0),--LEFT(D2))

[aaaaa34]

Yes @Bo_Ry , I have applied your latest formulas in attached file below.
But, two digits scores in halftime or fulltime mislead.

How can we solve it? Do you advice me to try VBA?

[aaaaa34]

any update?

[JeteMc]

On Sayfa2 try the following modifications of Bo_Ry's formulas:
1. E2 and down:

Please Login or Register  to view this content.

2. F2 and down:

Please Login or Register  to view this content.

3. J2 and down:

Please Login or Register  to view this content.

4. K2 and down:

Please Login or Register  to view this content.

Let us know if you have any questions.

[aaaaa34]

Despite I explained the case terribly and mistaken since beginning, @Bo_Ry never gave up helping me.
and your latest edit in his formula working great @JeteMc
Despite thread is getting older, you became interested in and solved it.
Marking it as solved.
Perfect. Thank you, thanks a lot bro.

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.