Hi Excel Masters,

Please provide you support in solving my below challenge with creating a formula fused with three criteria.

Say if the cells:
A1 = 3AB LT00022788 TH0000243428 JACKSON,LUCAS A 02/19/98 701-483-3456
A2 = 3AB LT00022788 TH0000243428 JACKSON,LUCAS B 02/19/98 701-483-3456
A3 = 3AB LT00022788 TH0000243428 JACKSON,LUCAS TC 02/19/98 701-483-3456

And When I put the below formulae in B1, B2 & B3:
=LEFT(A1,FIND(" A ",A1,1)-1)
=LEFT(A2,FIND(" B ",A1,1)-1)
=LEFT(A3,FIND(" TC ",A1,1)-1)

The resultant would be:
B1= 3AB LT00022788 TH0000243428 JACKSON,LUCAS
B2= 3AB LT00022788 TH0000243428 JACKSON,LUCAS
B3= 3AB LT00022788 TH0000243428 JACKSON,LUCAS

Challenge is to put a common formula that I can drag down from B1 to B3 that should give the above results.

Thanks in advance!!