Easily separate First Name from Last Name in Excel, including if there are middle names, and with no formulas. Simply use tables and fill series to separate the first name from the last name. In this video, I use the latest version of Excel that comes with Office 365.

Watch more Excel tutorial videos: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

– Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com

As full disclosure, I work at Microsoft as a full-time employee.

Please take the opportunity to connect and share this video with your friends and family if you find it useful.