-
Extracting Last name, First Name and sometimes Middle Name
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
-
Hi there, welcome to the board!
Take a look at Chip Pearson's site: http://www.cpearson.com/Excel/FirstLast.htm
HTH
-
-
Please mark your thread as Solved from the Thread Tools drop down (above your first post).
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules