I have a list of employee names that follow the Last name, First name Middle initial format. The formula I have works 95% of the time for employees with one last name, but it doesn't work when there is an employee that has two last names. I am looking to update my formula to accommodate the two last name employees:
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Employee Name[/TD]
[/TR]
[TR]
[TD]GEORGIA GREEN,CHRISTINE A[/TD]
[/TR]
[TR]
[TD]WILLIAMS TATE,TIFFANY K[/TD]
[/TR]
[TR]
[TD]THOMPSON HILL,COURTNEY F[/TD]
[/TR]
[TR]
[TD]RISHARD,STEVEN T[/TD]
[/TR]
[TR]
[TD]DAVIS,JORDAN V[/TD]
[/TR]
</tbody>[/TABLE]
Desired Result:
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]CHRISTINE GEORGIA GREEN[/TD]
[/TR]
[TR]
[TD]TIFFANY WILLIAMS TATE[/TD]
[/TR]
[TR]
[TD]COURTNEY THOMPSON HILL[/TD]
[/TR]
[TR]
[TD]STEVEN RISHARD[/TD]
[/TR]
[TR]
[TD]JORDAN DAVIS[/TD]
[/TR]
</tbody>[/TABLE]
Thank you!
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]Employee Name[/TD]
[/TR]
[TR]
[TD]GEORGIA GREEN,CHRISTINE A[/TD]
[/TR]
[TR]
[TD]WILLIAMS TATE,TIFFANY K[/TD]
[/TR]
[TR]
[TD]THOMPSON HILL,COURTNEY F[/TD]
[/TR]
[TR]
[TD]RISHARD,STEVEN T[/TD]
[/TR]
[TR]
[TD]DAVIS,JORDAN V[/TD]
[/TR]
</tbody>[/TABLE]
Desired Result:
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]CHRISTINE GEORGIA GREEN[/TD]
[/TR]
[TR]
[TD]TIFFANY WILLIAMS TATE[/TD]
[/TR]
[TR]
[TD]COURTNEY THOMPSON HILL[/TD]
[/TR]
[TR]
[TD]STEVEN RISHARD[/TD]
[/TR]
[TR]
[TD]JORDAN DAVIS[/TD]
[/TR]
</tbody>[/TABLE]
Code:
=IFERROR(MID(A1,FIND(",",A1)+1,FIND(" ",A1&" ")-FIND(",",A1)-1)&" "&LEFT(A1,FIND(",",A1)-1),"")
Thank you!