I have list of names in the format of Last Name, First Name Middle Initial. The problem is not every single name has a middle initial and I am looking to make a formula to put the names in First Name Last Name format. Here is the list and the formula I have so far:
Extract first name formula:
Extract last name formula:
List of names:
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]WILLIS,GEORGE A[/TD]
[/TR]
[TR]
[TD]GREEN,RICK[/TD]
[/TR]
[TR]
[TD]THOMAS-MATTS,CHARLOTTE R[/TD]
[/TR]
[TR]
[TD]PEPPERS,BONNIE[/TD]
[/TR]
[TR]
[TD]MONTEL,DWIGHT F[/TD]
[/TR]
[TR]
[TD]HARVER,JORDAN[/TD]
[/TR]
</tbody>[/TABLE]
Desired Result:
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]GEORGE WILLIS[/TD]
[/TR]
[TR]
[TD]RICK GREEN[/TD]
[/TR]
[TR]
[TD]CHARLOTTE THOMAS-MATTS[/TD]
[/TR]
[TR]
[TD]BONNIE PEPPERS[/TD]
[/TR]
[TR]
[TD]DWIGHT MONTEL[/TD]
[/TR]
[TR]
[TD]JOARDAN HARVER[/TD]
[/TR]
</tbody>[/TABLE]
Thank you for the assistance!
Extract first name formula:
Code:
=MID(A1,FIND(",",A1)+1,LEN(A1))
Extract last name formula:
Code:
=LEFT(A1,FIND(",",A1)-1)
List of names:
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]WILLIS,GEORGE A[/TD]
[/TR]
[TR]
[TD]GREEN,RICK[/TD]
[/TR]
[TR]
[TD]THOMAS-MATTS,CHARLOTTE R[/TD]
[/TR]
[TR]
[TD]PEPPERS,BONNIE[/TD]
[/TR]
[TR]
[TD]MONTEL,DWIGHT F[/TD]
[/TR]
[TR]
[TD]HARVER,JORDAN[/TD]
[/TR]
</tbody>[/TABLE]
Desired Result:
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]GEORGE WILLIS[/TD]
[/TR]
[TR]
[TD]RICK GREEN[/TD]
[/TR]
[TR]
[TD]CHARLOTTE THOMAS-MATTS[/TD]
[/TR]
[TR]
[TD]BONNIE PEPPERS[/TD]
[/TR]
[TR]
[TD]DWIGHT MONTEL[/TD]
[/TR]
[TR]
[TD]JOARDAN HARVER[/TD]
[/TR]
</tbody>[/TABLE]
Thank you for the assistance!