Extracting Last name, First Name and sometimes Middle Name

[dle]

Hi,

First time poster here and new to Excel. I am trying to figure out how to write an equation to separate first names, last names and sometimes a middle name. Some last names are sometimes two words. And there is a comma that is used after the last name. Any help will be greatly appreciated. Examples below:

Smith, Bill
Jones, Jim R
Dela Cruz, Jesse
Dela Cruz, Jim J

[Zack Barresse]

Hi there, welcome to the board!

Take a look at Chip Pearson's site: http://www.cpearson.com/Excel/FirstLast.htm

HTH

[dle]

This works!

[Zack Barresse]

Please mark your thread as Solved from the Thread Tools drop down (above your first post).