need help with a formula to separate a list of names into first, middle initials and last

[AVFoster]

i am having some trouble getting the result i need...i have a list of names first,middle initial(s) and last as shown below..
[TABLE="width: 193"]
<tbody>[TR]
[TD]Marley I. N. Alleyne[/TD]
[/TR]
[TR]
[TD]Alissa G. Baptiste-Pierre[/TD]
[/TR]
[TR]
[TD]Olianna S. Bishop[/TD]
[/TR]
[TR]
[TD]Russell S. M. Butcher[/TD]
[/TR]
[TR]
[TD]Devon P. Bynoe
[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
all of the formulas i try seem to work fine when there is only one middle initial but the instance where there are two the results are off.
would appreciate any help.

 

[AVFoster]

Brilliant! Thanks to all for the assist!

 

[FlameRetired]

Thanks for the feedback.