Our office has a list of some thousands of names written like this..
Smith, Rebbecca Carter
Doe, Jane Smith
Bacon, Dan Parker
Crawford, Sara Lopez
that I have to separate into cells for Last Name | First Name | Middle Name
my problem is when it is a two-part first name.
Fisher, Mary Anne Castro
What is a universal formula that can be used for all these names and get the correct split data?
Bookmarks