Separating a cell containing person last name nad first name with comma into 2 separate cells

[stvK23]

Hi

I am trying to separate a cell (Employee Name) into First Name and Last Name into separate cells.

[TABLE="class: grid, width: 500, align: left"]
<TBODY>[TR]
[TD]Employee Name[/TD]
[TD]First Name[/TD]
[TD]Last Name[/TD]
[/TR]
[TR]
[TD]WILLIAMS, John Peter[/TD]
[TD]John[/TD]
[TD]Williams[/TD]
[/TR]
</TBODY>[/TABLE]





[TABLE="width: 348"]
<TBODY>[TR]
[TD]Thanks[/TD]
[TD]</SPAN>[/TD]
[/TR]
[TR]
[TD]S[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL></COLGROUP>[/TABLE]

 

[Rick Rothstein]

Hi

I am trying to separate a cell (Employee Name) into First Name and Last Name into separate cells.

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Employee Name[/TD]
[TD]First Name[/TD]
[TD]Last Name[/TD]
[/TR]
[TR]
[TD]WILLIAMS, John Peter[/TD]
[TD]John[/TD]
[TD]Williams[/TD]
[/TR]
</tbody>[/TABLE]

Try this formulas...

First Name: =TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",99)),100,99))

Last Name: =PROPER(LEFT(A1,FIND(",",A1)-1))

 

[stvK23]

Thank you very much.. you make it so easy!