How to Split NAMES into First, Middle & Last Name | Using LEFT, MID, RIGHT, SEARCH Functions

Learn how to split full names in Excel into First, Middle, and Last Names using simple formulas like LEFT, MID, RIGHT, SEARCH, and LEN. This is perfect for users working with older Excel versions (before Excel 365) without TEXTSPLIT. Super easy and practical for day-to-day Excel reporting and data cleaning tasks.
📌 Formulas Used:

First Name: =IFERROR(LEFT(B2, SEARCH(" ", B2) - 1), B2)

Middle Name: =IFERROR(TRIM(MID(B2,SEARCH(" ",B2)+1,SEARCH(" ",B2,SEARCH(" ",B2)+1)-SEARCH(" ",B2))),"-")
Last Name: =IF(LEN(B2)-LEN(SUBSTITUTE(B2," ",""))=0, "-",
IF(LEN(B2)-LEN(SUBSTITUTE(B2," ",""))=1,
RIGHT(B2,LEN(B2)-SEARCH(" ",B2)),
RIGHT(B2,LEN(B2)-SEARCH(" ",B2,SEARCH(" ",B2)+1))
)
)
👉 Bonus tip: If you're using Excel 365/2021, try the TEXTSPLIT function for a faster solution.

Видео How to Split NAMES into First, Middle & Last Name | Using LEFT, MID, RIGHT, SEARCH Functions канала Excel the Excel