Inverting last name/first name to fuirst name/las name

[kimsa]

Have:

Jones, Mary / Jones, Sam (or could be three names) Jones, Mary / Jones, Sam / Jones, Tom

Need:

Mary Jones; Sam Jones (or all three names if case may be)

 

[oldbrewer]

all in one cell ie 3 names in A1 ?

 

[JoeMo]

Here's a UDF you can try. Copy B1 down.

Excel Workbook
	A	B
1	Jones, Mary / Jones, Sam / Jones, Tom	Mary Jones; Sam Jones; Tom Jones
2	Jones, Mary / Jones, Sam	Mary Jones; Sam Jones
3	Jones, Al	Al Jones
Sheet1

Function Kimsa(S As String) As String
Dim Nam As Variant, i As Long
Nam = Split(S, "/")
For i = LBound(Nam) To UBound(Nam)
    Kimsa = Kimsa & "; " & Mid(Nam(i), InStr(Nam(i), ",") + 2) & " " & Left(Nam(i), InStr(Nam(i), ",") - 1)
Next i
Kimsa = WorksheetFunction.Trim(Mid(Kimsa, 3))
End Function