Lesson Description

Ever wondered how to split inconsistent text across Excel cells without the hassle? In this video, learn how to use Excel’s powerful TEXTBEFORE and TEXTAFTER functions to extract first names, middle names, and last names from a mix of formats. Whether you’re dealing with full middle names, initials, or no middle name at all, this guide breaks down the process step-by-step. You’ll also discover how to handle errors and clean up your data for perfect results. Master these functions for efficient data organisation in Excel!