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..

Marley I. N. Alleyne

Alissa G. Baptiste-Pierre

Olianna S. Bishop

Russell S. M. Butcher

Devon P. Bynoe

<tbody>
</tbody>

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.