Best way to split out text in following format

[Sundance_Kid]

I have text in the following format:

Clinton\Bill Jefferson
Trump\ Donald

What I want to do (ideally without a macro as my skills are non-existent) is change both names so they appear as:

Bill Clinton
Donald Trump

However, as you see in one instance there is only one first name - Donald where as in the other example there is a first and second name - Bill Jefferson - and I want it to only pull the first name.

Thanks.

 

[Fluff]

How about

Fluff.xlsm
	A	B
1
2	Clinton\Bill Jefferson	Bill Clinton
3	Trump\ Donald	Donald Trump
Sheet6

Cell Formulas
Range	Formula
B2:B3	B2	=TEXTJOIN(" ",,CHOOSECOLS(TEXTSPLIT(A2,{"\","\ "," "}),2,1))

 

[Sundance_Kid]

How about

Fluff.xlsm
	A	B
1
2	Clinton\Bill Jefferson	Bill Clinton
3	Trump\ Donald	Donald Trump
Sheet6

Cell Formulas
Range	Formula
B2:B3	B2	=TEXTJOIN(" ",,CHOOSECOLS(TEXTSPLIT(A2,{"\","\ "," "}),2,1))

Thank you Fluffy, very helpful. I don’t know how you figure these formulas out .

One related question, if the name was in the format
O Dwyer\ Michael the formula would return Dwyer O rather than Michael Dwyer.

Is there a way to build into the original formula that in instances like that, it returns Michael Dwyer rather than Dwyer O?

Thank you

 

[Fluff]

How about

=TEXTBEFORE(TRIM(TEXTAFTER(A2,"\"))," ",,,1)&" "&TEXTAFTER(TEXTBEFORE(A2,"\")," ",-1,,1)