Extract First, Middle & Last Names from a list of Names in Microsoft Excel

Extract First, Middle & Last Names from a list of Names in Microsoft Excel by Latest Functions in #excel 365 | One more way is to do with Power Query!

First Name: =TEXTBEFORE(A2," ")
Middle Name: =IFNA(TEXTBEFORE(TEXTAFTER(A2, " "), " "),"")
Last Name: =TEXTAFTER(A2," ",-1)