🔠 Sort Names by Last Name in Excel — No Helper Column Needed! Ever wanted to sort a list of full names by last name instead of first name? Here’s a one-line Excel formula that does it magically 👇 =SORTBY(A3:A12, TEXTAFTER(A3:A12, " "), 1) 💡 How it works: TEXTAFTER(A3:A12, " ") extracts the text after the first space — that’s the last name. SORTBY() then sorts the original list based on those extracted last names. ✅ No manual splitting ✅ Works dynamically ✅ Perfect for name lists, directories,

5.2K views · 27 reactions | ‼️ Comment "CLEAN" to come to me FREE Excel Training  How to split text across columns? Splitting text from one cell into multiple cells is a task that all Excel users face from time to time In my free training, I will show you two ways how you can split text by column quickly! ‼️ Comment "CLEAN" & I will send you the link to my FREE Excel Training  | Farizat Tabora | Facebook