How to Extract / Split the First, Middle & Last Names from Cell in Excel - Solved
How to Extract / Split the First, Middle & Last Names from Cell in Excel - Solved
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 yourself :) YOU CAN DO IT