I have a very long list of names that i need to seperate in A1 into different columns. Names include that following different structures:

Micky Mouse
Micky M. Mouse
Micky & Minny Mouse
Micky M. & Minny Mouse
Micky Mouse & Donald Duck
Dr. & Mrs. Donald Duck

The columns I have are:

FirstName B1
MiddleName C1
LastName D1
Spousefirst E1
Spouselast F1
Prefix G1

I have tried figuring the code out for myself, but I am somewhat new and need guidance. I need to basically send the infomation tothe proper column in the same row. Any help is appreciated! (fyi list is 1,000+ names)