formula pulling first name and middle name in same column

You'd be suprised that there's nothing on net addressing this specific case:
Amador,Felipe Jose
Baptiste,Roger

although you would think there should be.
Here there is no space between last and first.
=TRIM(A2)
Getting last is straight forward:
=LEFT(F2, FIND(",",F2)-1)

Pulling the first and middle initial, if exists, in separate columns is not so straight forward:
=MID(F2,FIND(",",F2,FIND(" ",F2)+1)+1,FIND(" ",F2))
That gives VALUE error