Separate Full String into Firstname, Middle Initial and Lastname by column

Question

Using Excel, how can I separate a full name string, eg:

    Juan I. Dela Cruz
    Jojo Rambo
    Unlce Sam
    Mary Ann J. San Jose

into output of 'Firstname','Middle Initial' and 'Lastname':

+----------+----------------+----------+
|Firstname | Middle Initial | Lastname |
+----------+----------------+----------+
|Juan      | I.             | Dela Cruz|
+----------+----------------+----------+
|Jojo      |                | Rambo    |
+----------+----------------+----------+
|Uncle     |                | Sam      |
+----------+----------------+----------+
|Mary Ann  | J.             | San Jose |
+----------+----------------+----------+

Answer 1

In Firstname: =IFERROR(LEFT(A1,FIND(".",A1)-3),LEFT(A1,FIND(" ",A1)-1))
In Middle Initial =IFERROR(MID(A1,FIND(".",A1)-1,2),"")
In Lastname =IFERROR(RIGHT(A1,LEN(A1)-FIND(".",A1)-1),RIGHT(A1,LEN(A1)-FIND(" ",A1)))

each copied down to suit may be a start (for the examples provided) but, for the reasons as mentioned by @lurker, this is not likely to be a comprehensive solution.