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?