🔠 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! Ever wan…
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
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 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
How to Split or Reverse First Last Names in Excel
4 months ago
contextures.com
Sort data in a range or table in Excel
Sort data in a range or table in Excel
Oct 28, 2014
Microsoft
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
2 Ways to Filter for List of Items in Excel Video Tutorial - Excel Campus
Jun 1, 2017
excelcampus.com
Excel 2016: Sorting Data
Jan 1, 2009
gcfglobal.org
3:26
Excel: Merge tables by matching column data or headers
Mar 16, 2023
ablebits.com
1:56
Excel: Split First and Last Name (Easily!)
6K viewsNov 21, 2022
YouTubeMark's Excel Tips
2:22
How to Split Full Name into First Name, Middle Name and Last Name i…
9K viewsNov 10, 2017
YouTubeExcel 10 tutorial
2:50
Using Named Ranges in Excel
18.1K viewsApr 21, 2017
YouTubeIQ Accounting Solutions
5:14
Excel Split Names Tutorial
574.3K viewsOct 16, 2017
YouTubeTechnology for Teachers and Students
3:38
How to Sort Alphabetically in Excel
654.2K viewsSep 24, 2019
YouTubeExcel Tutorials by EasyClick Academy
13:29
Excel Sorting and Filtering Data
1M viewsJun 7, 2018
YouTubeThe Organic Chemistry Tutor
5:17
Excel Splitting Names using a NEW Method
65.1K viewsJan 7, 2016
YouTubeMS Office Tutorials
3:21
How to Separate Names in Excel
392.7K viewsAug 20, 2019
YouTubeExcel Tutorials by EasyClick Academy
4:25
How to Separate Names in Excel
208.7K viewsJan 14, 2020
YouTubeKevin Stratvert
13:24
Spreadsheets: How to Sort Data Onto Sub Sheets
69.5K viewsMar 29, 2017
YouTubeDave Foord
9:17
Randomly Assign Names to Groups - Excel Formula
164.7K viewsAug 21, 2018
YouTubeComputergaga
8:31
Excel: Combine the awesome UNIQUE and SORT functions in Excel
29.2K viewsApr 14, 2021
YouTubeChris Menard
3:33
How To Sort Based on Multiple Columns in Excel
12.6K viewsJul 18, 2021
YouTubeExcel 10 tutorial
5:36
How to Do Multi level sorting in Excel (by two Columns)
212.9K viewsMay 16, 2018
YouTubeTrumpExcel
3:35
How to Quickly Rearrange Column Order in Excel
291K viewsJun 9, 2014
YouTubeDanny Rocks
3:23
How to Sort Names Alphabetically through Formula in Excel
1.1K viewsDec 20, 2017
YouTubeExcelWay
1:53
How To Sort Data Containing Merged Cells in Excel 2013/2016
66.6K viewsNov 7, 2018
YouTubeExcelHow Tech
2:06
How to sort by multiple columns in Excel
297K viewsJan 25, 2016
YouTubeBarb Henderson
6:01
How to Sort and Filter Your Data in Excel
53.9K viewsMar 30, 2021
YouTubeSimply Excel
3:42
Multi-Level or Custom Sorting in MS Excel | Excel Tutorial to Arrange & So…
11K viewsJan 26, 2021
YouTubeMicrosoft Office Tutorials
See more videos
Static thumbnail place holder