Split Full Name into First, Middle & Last in Excel | Easy Formula Tricks! Want to extract First Name, Middle Name, and Last Name from a full name in Excel? In this quick tutorial, you'll learn easy and powerful formulas using LEFT, RIGHT, MID, FIND, and SUBSTITUTE — no complex coding or VBA needed! Perfect for Excel beginners and pros who deal with messy name data. Works for: 2-part names (e.g., John Smith) 3-part names (e.g., John Michael Smith) Even single names (e.g., Anjali) Topics Covered: