🔠 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…
406 views1 month ago
FacebookExcel Tricks.
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
Separate First and Last Name in Excel (Split Names Using Formulas)
19:52
Separate First and Last Name in Excel (Split Names Using Formulas)
Sep 21, 2019
trumpexcel.com
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
Get last name from name
Get last name from name
Oct 26, 2022
exceljet.net
How to Sort Data in Excel Spreadsheets (The Right Way) | Envato Tuts
How to Sort Data in Excel Spreadsheets (The Right Way) | E…
Jun 7, 2017
tutsplus.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
How to Split or Reverse First Last Names in Excel
4 months ago
contextures.com
1:09
Sort data in a range or table in Excel
Oct 28, 2014
Microsoft
0:33
How to Sort Names by Surname in Excel #shorts #education
14 views1 month ago
YouTubePeak Productivity Pro
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
577.8K viewsOct 16, 2017
YouTubeTechnology for Teachers and Students
1:34
How to Sort Alphabetically in Excel
132.7K viewsApr 15, 2020
YouTubeHow-to Videos
3:38
How to Sort Alphabetically in Excel
655.9K viewsSep 24, 2019
YouTubeExcel Tutorials by EasyClick Academy
13:29
Excel Sorting and Filtering Data
1M viewsJun 7, 2018
YouTubeThe Organic Chemistry Tutor
3:21
How to Separate Names in Excel
394.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.1K viewsJan 14, 2020
YouTubeKevin Stratvert
6:16
How to Sort and Filter Data in Excel 2016
149.8K viewsMar 5, 2018
YouTubeKnowledgeCity
1:26
How to sort by date in Microsoft excel
976.1K viewsFeb 2, 2016
YouTubeSagar S (Vishal)
6:01
How to Sort and Filter Your Data in Excel
55.2K viewsMar 30, 2021
YouTubeSimply Excel
1:12
Sorting and Filtering in Excel | Excel in Minutes
15.1K viewsFeb 20, 2015
YouTube3 Minutes Tutorial
0:53
How to Sort Excel Data in Ascending or Descending Order
234.1K viewsNov 9, 2019
YouTubeFigureAssist
1:40
No Formula-Separate First Name & Last Name in MS Excel
347.3K viewsMar 5, 2019
YouTubeMJ Tube
2:47
2 Easy Ways to Separate First & Last Names in Excel
6.4K viewsNov 19, 2020
YouTubeSimple Software Tutorials
10:26
Excel: Split First Name and Last Name. Then, Re-connect them.
14.7K viewsJan 5, 2016
YouTubeMS Office Tutorials
1:50
SPLIT names in Excel - Separate First, Middle and Last Name
18.8K viewsOct 3, 2019
YouTubeExcel Bootcamp
3:38
Sort Names in the Alphabetical Order Last Names [SORTBY Funct…
7.7K viewsMay 2, 2020
YouTubeAjay Anand
14:00
Sort Full Name by Last Name in Excel | Sort by Last Word in Cell (…
59.4K viewsJan 25, 2021
YouTubeChester Tugwell
1:14
How To Flip The First And Last Name In Cells In Excel
10.8K viewsFeb 12, 2019
YouTube28 November 2016
See more videos
Static thumbnail place holder