This one's a toughie... be prepared!

I have a spreadsheet with several thousand entries that should have been a
database instead. It holds a lot of user information, such as names,
numbers, addresses, etc.

I need to the entries under the Name column into multiple colums.
Specifically, Title1, First1, Middle1, Last1, Suffix1, Title2, First2,
Middle2, Last2, Suffix2. Of course, all the entries under the Name column
are not standard:

Craig and Dolores Craig
Jeffrey and Cynthia Beegle
Jason Piel
Mr Kaske
Debra Cork-Wahl and Charles Cork
Micro Systems
Matthew G. Kovar and Karina Rand-Kovar
Terrance and Mary Mathews

The most common format is "First1 and First2 Last1/2", but that is not the
case with a good chunk of the entries. No matter how you look at it, someone
is going to have to go through it manually to make sure there are no
mistakes, but I was hoping that there would be some way to script a
semi-solution to cut down on some of the work.

Any takers? :-)

Thanks!

Nick