Remove Commas & Middle Initial, Flip First and Last Name

or If You like VBA like me You can use this small UDF

Function name(rng)

Dim tb As Variant

tb = Split(Left(rng, Len(rng) - 2), ",")

name = tb(1) & " " & tb(0)

End Function