🔠 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.7K views1 month 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
SORT Function
SORT Function
Nov 2, 2023
exceljet.net
A Step by Step Guide on How to Sort Data in Excel
A Step by Step Guide on How to Sort Data in Excel
Feb 19, 2021
simplilearn.com
How to Sort Columns in Excel (Without Mixing Data)
How to Sort Columns in Excel (Without Mixing Data)
Jan 10, 2023
spreadsheeto.com
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
Excel: Sorting Data
Excel: Sorting Data
Mar 15, 2019
gcfglobal.org
1:09
Sort data in a range or table in Excel
Oct 28, 2014
Microsoft
0:55
Filter data in a range or table in Excel
Oct 28, 2014
Microsoft
37:16
Sorting, Multi-Level Sorting, and Custom Sorting in Excel – Comple…
115 views4 weeks ago
YouTubeIT TECH
3:58
Excel data sorting, Excel sort function, how to sort data in Excel…
6 views1 month ago
YouTubeExcel & Tally with Dipankar
11:43
Excel Tutorial - Sort Data Automatically based on multiple c…
25.5K viewsNov 19, 2019
YouTubeTEKNISHA
3:18
Sorting Data Randomly In Excel
42.5K viewsJul 29, 2014
YouTubeK2 Enterprises
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.5K viewsSep 24, 2019
YouTubeExcel Tutorials by EasyClick Academy
5:32
Sorting and Filtering Data In Microsoft Excel (Tutorial)
5.1K viewsDec 12, 2018
YouTubeExcel with Business
13:29
Excel Sorting and Filtering Data
1M viewsJun 7, 2018
YouTubeThe Organic Chemistry Tutor
2:56
How to Sort by Date in Excel - ExcelPro
70.9K viewsMay 11, 2019
YouTubeExcel Pro
3:21
How to Separate Names in Excel
393.6K viewsAug 20, 2019
YouTubeExcel Tutorials by EasyClick Academy
0:23
Excel Sort Alphabetically / Alphabetize Column (2020) - 1 MIU…
117.5K viewsNov 30, 2020
YouTubeLeon Renner
7:57
VBA to Sort Data in Excel - Excel VBA Tutorial
59.9K viewsOct 28, 2018
YouTubeExcel Destination
1:06
How to filter data in a range or table in Microsoft Excel
452.5K viewsFeb 17, 2021
YouTubeMicrosoft 365
13:24
Spreadsheets: How to Sort Data Onto Sub Sheets
69.5K viewsMar 29, 2017
YouTubeDave Foord
6:16
How to Sort and Filter Data in Excel 2016
149.6K viewsMar 5, 2018
YouTubeKnowledgeCity
3:29
Google Sheets Sort Function | Sort Data in Ascending or Descending …
232.2K viewsNov 5, 2020
YouTubeSoftware Spring
7:43
How to Sort Data in Excel Automatically Using Rank and VL…
55.3K viewsMar 8, 2018
YouTubePrabas Office Studio
5:57
Excel - Sort Unorganized Data (rows and columns together)
5.1K viewsJun 2, 2014
YouTubeJalayer Academy
8:31
Excel: Combine the awesome UNIQUE and SORT functions in Ex…
29.4K viewsApr 14, 2021
YouTubeChris Menard
1:26
How to sort by date in Microsoft excel
976.1K viewsFeb 2, 2016
YouTubeSagar S (Vishal)
3:33
How To Sort Based on Multiple Columns in Excel
12.6K viewsJul 18, 2021
YouTubeExcel 10 tutorial
See more videos
Static thumbnail place holder