Order Arrangment IF Statement

[T2D2]

Is there a formula that will go through a column with mixed names and rearrange the ones that contain the format last name, first name and leave the first name last names alone?

Original Result
Smith, John John Smith
Terry Bradshaw Terry Bradshaw
Carter, Gary Gary Carter

 

[Egress1]

Hi T2D2,

If your names are in Column A you can use a helper column and this formula copy it down the entire list. When finished copy the results and paste special back to column A as VALUES

=IF(ISERROR(SEARCH(",",A1)),A1,RIGHT(A1,LEN(A1)-SEARCH(",",A1)-1) & " " & LEFT(A1,SEARCH(",",A1)-1))

 

[T2D2]

PERFECT! Thanks a ton...