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