🔠 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 amharc3 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)
11 Ean 2020
trumpexcel.com
Extract Last Name in Excel (5 Easy Ways)
7:02
Extract Last Name in Excel (5 Easy Ways)
27 Ean 2022
trumpexcel.com
How to SORT in Excel (by Rows, Columns, Colors, Dates, & Numbers)
5:36
How to SORT in Excel (by Rows, Columns, Colors, Dates, & Numbers)
16 Beal 2018
trumpexcel.com
SORT Function
SORT Function
2 Samh 2023
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)
30 Meith 2021
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)
21 MFómh 2019
trumpexcel.com
Get last name from name
26 DFómh 2022
exceljet.net
Sort data in a range or table in Excel
28 DFómh 2014
Microsoft
How to Separate Names in Excel (Split First and Last)
14 Noll 2022
spreadsheeto.com
How to Split or Reverse First Last Names in Excel
4 months ago
contextures.com
0:38
✅ Excel Shortcut: Split First Name & Last Name with TEXTAFTER
3.4K amharc2 months ago
YouTubeGUIDE OF MAD - EXCEL
0:35
Sort Names by Last Name in Excel — No Helper Column Needed!
2.4K amharc3 weeks ago
YouTubeXLGenAI
0:33
Sort Names by Length in Excel in Seconds! | Simple Excel Trick You Di…
25 amharc1 month ago
YouTubeMalzTech
1:12
📊 How to Sort Data in Excel (2025) – Sort Data From A to Z, Ascending or …
220 amharc2 months ago
YouTubeKbroda Tech
Get last name from name with comma
26 DFómh 2022
exceljet.net
5:14
Excel Split Names Tutorial
574.3K amharc16 DFómh 2017
YouTubeTechnology for Teachers and Students
3:00
Using Custom Sort in Microsoft Excel
20.6K amharc23 Feabh 2023
YouTubeSimon Sez IT
3:28
How to sort data in Excel
30.4K amharc15 Feabh 2023
YouTubeTechOnTheNet
1:34
How to Sort Alphabetically in Excel
132.6K amharc15 Aib 2020
YouTubeHow-to Videos
16:51
How to SORT Data in Excel | 7 Tips
151.8K amharc26 Iúil 2022
YouTubeChris Menard
3:38
How to Sort Alphabetically in Excel
654.2K amharc24 MFómh 2019
YouTubeExcel Tutorials by EasyClick Academy
0:11
EXCEL Tricks For Easy Name Sorting
520 amharc9 months ago
YouTubeThe Positive Peach
13:29
Excel Sorting and Filtering Data
1M amharc7 Meith 2018
YouTubeThe Organic Chemistry Tutor
1:20
How to sort data in Excel | Microsoft
91.3K amharc18 Noll 2022
YouTubeMicrosoft Helps
8:20
Sorting by Custom Lists in Excel
77.2K amharc28 Lún 2023
YouTubeTechnology for Teachers and Students
2:56
How to Sort by Date in Excel - ExcelPro
70.9K amharc11 Beal 2019
YouTubeExcel Pro
3:21
How to Separate Names in Excel
392.7K amharc20 Lún 2019
YouTubeExcel Tutorials by EasyClick Academy
4:00
How to reorder columns in excel | 4 methods
51.6K amharc29 Márta 2023
YouTubeKarina Adcock
4:25
How to Separate Names in Excel
208.7K amharc14 Ean 2020
YouTubeKevin Stratvert
Féach tuilleadh físeán
Sealbhóir áite mionsamhlacha statach