Excel Question

[KWR21]

Hello, I have a question about this question I need answered. The question wants me to figure out what formula I could use to parse the last names and first names that exclude the titles and trim the spaces.

Some of the names on the long list are:
Mr. Yang Scott
Dr. Peterson James
Ms. Wenzel Ashley.

 

[awoohaw]

If there are no suffixes or middle initials then you can try this:

Book1
	A	B	C
1
2	Mr. Yang Scott	Yang	Scott
3	Dr. Peterson James	Peterson	James
4	Ms. Wenzel Ashley	Wenzel	Ashley
5	Mr. WWL RFJX	WWL	RFJX
6	Mr. CJX CHYK	CJX	CHYK
7	Mr. OVU BHIA	OVU	BHIA
8	Mr. AUD GJRQ	AUD	GJRQ
9	Mr. YDQ KDXK	YDQ	KDXK
10	Mr. ETQ PTNY	ETQ	PTNY
11	Mr. PEK RSUZ	PEK	RSUZ
12	Mr. AFP SVOM	AFP	SVOM
13	Mr. VTY MUJS	VTY	MUJS
14	Mr. TQB GBLU	TQB	GBLU
Sheet1

Cell Formulas
Range	Formula
B2	B2	=TEXTAFTER(TEXTBEFORE($A2," ",2)," ")
C2:C14	C2	=TEXTAFTER($A2," ",2)
B3:B14	B3	=TEXTAFTER(TEXTBEFORE(A3," ",2)," ")