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:
<tbody>
</tbody>
Desired Result:
<tbody>
</tbody>
Thank you!
Employee Name |
GEORGIA GREEN,CHRISTINE A |
WILLIAMS TATE,TIFFANY K |
THOMPSON HILL,COURTNEY F |
RISHARD,STEVEN T |
DAVIS,JORDAN V |
<tbody>
</tbody>
Desired Result:
CHRISTINE GEORGIA GREEN |
TIFFANY WILLIAMS TATE |
COURTNEY THOMPSON HILL |
STEVEN RISHARD |
JORDAN DAVIS |
<tbody>
</tbody>
Code:
=IFERROR(MID(A1,FIND(",",A1)+1,FIND(" ",A1&" ")-FIND(",",A1)-1)&" "&LEFT(A1,FIND(",",A1)-1),"")
Thank you!