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

How to separate Given name, Last name and Middle Initial using Microsoft excel #exceltips #teachers-hack #Lesshassle #icthacks #followformore | Teachër Edlyn