PDA

View Full Version : [SOLVED] Extracting Last name, First Name and sometimes Middle Name



dle
12-04-2014, 03:19 PM
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
12-04-2014, 03:21 PM
Hi there, welcome to the board!

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

HTH

dle
12-04-2014, 03:47 PM
This works!

Zack Barresse
12-04-2014, 03:53 PM
Please mark your thread as Solved from the Thread Tools drop down (above your first post). :)