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)
13 янв 2023