Need help in Text To Column

[Svk2005]

Cell A1 value = “ABC VIN DIESEL 1223 XYZ Robert Mannkor 665435 ABC JK PATEL 785589 XYZ Tom Cruise....”

the single cell contains huge lines of text data and I want to the text on this cell to be converted into columns

the excel has to do the following
1) the keywords are ABC and XYZ
2) Any number of words that suffice this keywords UNTIL next keyword should get into new rows
for example
ABC VIN DIESEL 1223
XYZ Robert Mannkor 665435
ABC JK PATEL 785589

Any help is greatly appreciated! ?

 

[CA_Punit]

Book1
	B
14	Data
15	ABC VIN DIESEL 1223 XYZ Robert Mannkor 665435 ABC JK PATEL 785589 XYZ Tom Cruise
16
17
18	VIN DIESEL 1223
19	Robert Mannkor 665435
20	JK PATEL 785589
21	Tom Cruise
Sheet2

Cell Formulas
Range	Formula
B17:B26	B17	=TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Table1[Data],"ABC "," | "),"XYZ "," | ")," | ",REPT(" ",LEN(Table1[Data]))),(ROW(1:10)-1)*LEN(Table1[Data])+1,LEN(Table1[Data])))
Dynamic array formulas.

 

[CA_Punit]

It will work with only two Identification "ABC" & "XYZ" if you have other delimiters use Substitute function more times

 

[Svk2005]

It will work with only two Identification "ABC" & "XYZ" if you have other delimiters use Substitute function more times

Thank you very much! ?