2.5M views · 34K reactions | Excel-ல் இந்த Tricks-ஐ Follow பண்ணுங்க #SuryanFM #suryanexpalin #excel #microsoft #microsoftexcel #office #word #powerpoint #business #cursodeexcel #data #msexcel #cursoexcel #powerbi #exceltips #motivation #datascience #microsoftoffice #aprenderexcel #planilhas #dicasexcel #windows #dashboard #cursos #ado #exceltraining #excelbasico #dataanalytics | SuryanFM | Facebook

🔠 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,