🔠 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
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 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
Combine First and Last Names in Excel & Google Sheets
Combine First and Last Names in Excel & Google Sheets
Oct 28, 2023
automateexcel.com
Switch First & Last Names w/ Commas - Excel & Google Sheets
Switch First & Last Names w/ Commas - Excel & Google Sheets
Feb 8, 2023
automateexcel.com
Flip Data in Excel | Reverse Order of Data in Column/Row
10:27
Flip Data in Excel | Reverse Order of Data in Column/Row
Mar 2, 2021
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
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
7:02
Extract Last Name in Excel (5 Easy Ways)
Jan 27, 2022
trumpexcel.com
0:15
Combining First and Last Name in Excel: Easy Tutorial!
11.3K viewsFeb 17, 2023
TikTokexcelbyrob
0:58
How to Separate First, Middle and Last Names in Excel #excel #offic…
1.1K views2 weeks ago
YouTubePVC Official
1:08
Switch First and Last Names in Excel — Quick & Easy Trick!
80 views4 weeks ago
YouTubeExtendOffice
4:28
Replace First and Last Names Excel Tricks
2 months ago
YouTubeExcel Pro 4 Future
4:08
Reverse Names with Excel MID Function
2.4K viewsApr 9, 2021
YouTubeContextures Inc.
Flip first last names in cells
637 viewsDec 31, 2021
YouTubeExtendOffice
Get last name from name with comma
Oct 26, 2022
exceljet.net
5:14
Excel Split Names Tutorial
575K viewsOct 16, 2017
YouTubeTechnology for Teachers and Students
2:58
Reverse or Flip Data range in Excel
2.9K viewsMar 7, 2021
YouTubeExcelTips
5:17
Excel Splitting Names using a NEW Method
65.2K viewsJan 7, 2016
YouTubeMS Office Tutorials
3:21
How to Separate Names in Excel
393.3K viewsAug 20, 2019
YouTubeExcel Tutorials by EasyClick Academy
5:34
How to Reverse or flip data range in Excel
262.3K viewsMay 15, 2018
YouTubeExcel Rush
4:25
How to Separate Names in Excel
208.9K viewsJan 14, 2020
YouTubeKevin Stratvert
3:31
How to Reverse or Flip a Column in Excel
29.7K viewsSep 16, 2020
YouTubeSoftTech Tutorials
9:00
Reverse First and Last Names in Excel
69.3K viewsMay 25, 2015
YouTubeContextures Inc.
4:42
How to Combine First and Last Name in Excel
572.1K viewsOct 8, 2019
YouTubeExcel Tutorials by EasyClick Academy
0:16
Excel: How to Move to First or Last Row in a List
14K viewsJul 17, 2013
YouTubeFinance Train
2:47
2 Easy Ways to Separate First & Last Names in Excel
7.1K 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
14:00
Sort Full Name by Last Name in Excel | Sort by Last Word in Cell (…
58.3K viewsJan 25, 2021
YouTubeChester Tugwell
See more videos
Static thumbnail place holder