1.9K views · 79 reactions | 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) | Excel Basement | Facebook

4K views · 67 reactions | How to Extract / Split the First, Middle & Last Names from Cell in #Excel Formula: First Name: =LEFT(B4,FIND(" ",B4)-1) Middle Name: =MID(B4,FIND(" ",B4)+1,(FIND(" ",B4,FIND(" ",B4)+1)-FIND(" ",B4))-1) Last Name: Do it by yourself :) YOU CAN DO IT | Excel Basement | Facebook