🔠 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

53K views · 381 reactions | Curious about how to efficiently manage your data in Excel? 樂 Check out this quick guide on splitting data effortlessly! You'll be amazed at how much easier it can make your workflow. ✨  Comment "START” to get a FREE Excel Starter Pack! #excel #exceltips #spreadsheets #productivityhacks #office #finance #accounting #microsoftexcel #datamanagement | Excel Campus | Facebook