"Reverse concatenate"

[panyagak]

Hi Mrexcel Experts.

I copied this data below from a website, pasted to Excel in my small Smartphone but pasted in just one column.

I want it to be in separate columns.

Kindly help out.

Regards

23:00 Barcelona Atletico - Universidad O&M 2.99 3.24 2.12 1
23:00 Clan Juvenil - LDU Loja 2.54 3.16 2.47 5
23:00 Ferroviaria - Cianorte 1.81 3.53 3.69 16
23:00 Paysandu PA - Luverdense 1.67 3.47 4.89 21
23:00 Santa Rita - Orense 2.28 2.98 3.04 4

Example 1:
23:00 Barcelona Atletico - Universidad O&M 2.99 3.24 2.12 1
To be;
|23:00 |Barcelona Atletico - Universidad O&M| 2.99 |3.24 |2.12| 1| as columns

 

[Bo_Ry]

Text at A1

Please try

B1 =LEFT(A2,5)
C1 =MID(LEFT(A2,FIND(D2,A2)-2),FIND(" ",A2)+1,50)
D1:G1 =TRIM(LEFT(RIGHT(SUBSTITUTE($A2," ",REPT(" ",50)),50*COLUMNS(D2:$G2)),50))

 

[panyagak]

Bo_Ry

HEAVENLY PERFECT FOR A "NEW MEMBER ". Thanks SO SO MUCH!!

SORRY for taking time; Just tested it NOW after updating my Android Playstore.

Regards
Patrick