Excel - Parsing Data

[santa12345]

Hi .
I am trying to parse the following.

Column H is my source that I am trying to parse. Part Description
Column I is the first sub part (always starting on the left hand side and continuing until the first space in the text) various lengths and various starting text (HKL vs E, etc..)
Column J is the second sub part (always starting after the first space) various lengths and various starting text
Column K is the third sub part (if there is one...always starting after the second space) various lengths and various starting text
Column L is the 4th sub part (always at the end of the text in Column H) this will always start with TL

I tried using Mid function but the first, second and 3rd sub parts may start with different text letters so not sure if a formula be written based on the spaces possibly ?
Thanks again.

 

[kweaver]

Please use XL2BB to display your sample data so that anyone trying to help doesn't have to type your data.

 

[santa12345]

Sorry..how do i attach a file?

 

[bobsan42]

This is based on the submitted data:

MrExcel Tests 2021.xlsm
	H	I	J	K	L
1	Part description	Sub Part 1	Sub Part 2	Sub Part 3	Sub Part 4
2	HKL38 SSPN38-23.40 labeled with TL.323.1	HKL38	SSPN38-23.40		TL.323.1
3	E121H-4 AAPN12-13.65 HF375T-30.20 labeled with TL.319.2	E121H-4	AAPN12-13.65	HF375T-30.20	TL.319.2
4	HKL75S SSPN34-17.30 labeled with TL.301.6	HKL75S	SSPN34-17.30		TL.301.6
5	E121H-4 CCPN12-13.65 AA375T-32.55 labeled with TL.200.1	E121H-4	CCPN12-13.65	AA375T-32.55	TL.200.1
Sheet1

Cell Formulas
Range	Formula
I2:I5	I2	=LEFT(H2,FIND(" ",H2)-1)
J2:J5	J2	=LEFT(RIGHT(H2,LEN(H2)-LEN(I2)-1),FIND(" ",RIGHT(H2,LEN(H2)-LEN(I2)-1))-1)
K2:K5	K2	=TRIM(SUBSTITUTE(MID(H2,LEN(I2&J2)+3,LEN(H2)-LEN(I2&J2&L2)-3),"labeled with",""))
L2:L5	L2	=RIGHT(H2,LEN(H2)-FIND(" TL.",H2))

 

[santa12345]

As usual - excellent !! Thank you !!!!