Formula to reverse two sets of names in same cell

[neil40]

Hi

I wonder if someone could assist with a formula to reverse two sets of names in a cell please.
Scenario
I have been sent a large set of data where the names are like this

Smith Fred - Hunt George

I would like to change it to

Fred Smith/George Hunt

I've used =MID(A1&" "&A1,FIND(" ",A1)+1,LEN(A1)) before to reverse two names, but this goes beyond.

I'm not too worried about anomalies that might occur, I can manually edit them (where a middle name is introduced or a Jr or Sr is added)

Thanks for your thoughts
Neil

[JohnTopley]

Using "helper" columns with initial data in A1

in B1 =TRIM(MID(A1,1,FIND("-",A1)-2))

in C1 =TRIM(MID(A1,FIND("- ",A1)+2,255))

in D1 =MID(B1&" "&B1,FIND(" ",B1)+1,LEN(B1)) & "/" & MID(C1&" "&C1,FIND(" ",C1)+1,LEN(C1))

Hope this helps.

[Kaper]

Or another approach (if this is repeating task - could be done with macro).
If there is a hyphen between the two I'd do the following:
mark whole column do text to columns, separated and hyphen as the separation mark
then insert few (or more if there are names like Juan Carlos I Alfonso Víctor María de Borbón y Borbón-Dos Sicilias ) columns in between and again do text to columns on both subsets (now marking space as separator

and now final formula (somewhere in X1) would be like

= K1 & " " & J1 & " - " & B1 & " " & A1

or similar

[neil40]

Thanks both, I like both approaches and will test later to see which is easiest to implement.

Neil