🔠 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,
🔠 Sort Names by Last Name in Excel — No Helper Column Needed! Eve…
2.5K views3 weeks ago
FacebookExcel By Vikal
How to Sort by the Last Name in Excel (Easy Guide)
11:52
How to Sort by the Last Name in Excel (Easy Guide)
Jan 11, 2020
trumpexcel.com
How to Separate Names in Excel (Split First and Last)
How to Separate Names in Excel (Split First and Last)
Dec 14, 2022
spreadsheeto.com
Get first name from name
Get first name from name
Oct 26, 2022
exceljet.net
How to Combine First and Last Name in Excel (4 Easy Ways)
8:16
How to Combine First and Last Name in Excel (4 Easy Ways)
Jun 30, 2021
trumpexcel.com
Sort numbers ascending or descending
Sort numbers ascending or descending
May 17, 2024
exceljet.net
Get last name from name
Get last name from name
Oct 26, 2022
exceljet.net
Sort text and numbers with formula
Oct 26, 2022
exceljet.net
Switch First & Last Names w/ Commas - Excel & Google Sheets
Feb 8, 2023
automateexcel.com
How to Split or Reverse First Last Names in Excel
4 months ago
contextures.com
0:35
Sort Names by Last Name in Excel — No Helper Column Needed!
2.4K views3 weeks ago
YouTubeXLGenAI
0:49
Sort Excel Data Alphabetically in 10 Seconds! (Quick Right-Click Meth…
1.1K views3 weeks ago
YouTubeAkshrika Tutorials
4:01
How do I Alphabetize in Excel
913 viewsFeb 28, 2022
YouTubelearnexcel.video
2:31
How to sort numbers with text/ letter prefix or suffix in Excel
6.9K viewsMar 18, 2022
YouTubeExtendOffice
1:56
Excel: Split First and Last Name (Easily!)
6K viewsNov 21, 2022
YouTubeMark's Excel Tips
1:10
How to insert Alpha symbol in Excel
575 viewsSep 20, 2022
YouTubeDịch Thuật Á Đông
Extract First and Last Name in Excel using Text functions | Split name…
1.2K viewsDec 12, 2019
YouTubekarpagam Excel Prime
6:25
How to Extract Separate First Name, Middle Name, and Last Name on G…
6.6K viewsJul 11, 2021
YouTubeTongbos_EN
0:59
Get first and last name in Excel-one formula #shorts
10.5K viewsMay 22, 2023
YouTubeExcelMoments
3:35
MS Excel: How to Sort Value with Data (Large to Small & Ascending …
372.5K viewsJan 17, 2018
YouTubeMJ Tube
1:27
Sort Excel Worksheets in alphabetical order in 90 seconds
34.9K viewsJan 22, 2018
YouTubeKwikTrix
2:22
How to Split Full Name into First Name, Middle Name and Last Nam…
9K viewsNov 10, 2017
YouTubeExcel 10 tutorial
5:14
Excel Split Names Tutorial
573.5K viewsOct 16, 2017
YouTubeTechnology for Teachers and Students
1:34
How to Sort Alphabetically in Excel
132.6K viewsApr 15, 2020
YouTubeHow-to Videos
3:38
How to Sort Alphabetically in Excel
654.2K viewsSep 24, 2019
YouTubeExcel Tutorials by EasyClick Academy
3:21
How to Separate Names in Excel
392.4K viewsAug 20, 2019
YouTubeExcel Tutorials by EasyClick Academy
1:27
Sort alphanumeric data in Excel
27.4K viewsSep 1, 2017
YouTubePrashant Jain
4:25
How to Separate Names in Excel
208.5K viewsJan 14, 2020
YouTubeKevin Stratvert
0:23
Excel Sort Alphabetically / Alphabetize Column (2020) - 1 MIU…
115.9K viewsNov 30, 2020
YouTubeLeon Renner
1:05
How to Sort Excel by Alphabetical Order
4.3K viewsMay 29, 2018
YouTubeHOWZA
See more videos
Static thumbnail place holder