🔠 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,7K weergaven1 maand geleden
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 jan. 2020
trumpexcel.com
Extract Last Name in Excel (5 Easy Ways)
7:02
Extract Last Name in Excel (5 Easy Ways)
27 jan. 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 mei 2018
trumpexcel.com
SORT Function
SORT Function
2 nov. 2023
exceljet.net
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 sep. 2019
trumpexcel.com
Get last name from name
Get last name from name
26 okt. 2022
exceljet.net
How to Separate Names in Excel (Split First and Last)
14 dec. 2022
spreadsheeto.com
How to Split or Reverse First Last Names in Excel
4 maanden geleden
contextures.com
1:09
Sort data in a range or table in Excel - Microsoft Support
28 okt. 2014
Microsoft
0:33
How to Sort Names by Surname in Excel #shorts #education
14 weergaven2 weken geleden
YouTubePeak Productivity Pro
0:35
Sort Names by Last Name in Excel — No Helper Column Needed!
2,4K weergaven1 maand geleden
YouTubeXLGenAI
0:58
How to Separate First, Middle and Last Names in Excel #excel #office #spre…
1,1K weergaven3 weken geleden
YouTubePVC Official
1:12
📊 How to Sort Data in Excel (2025) – Sort Data From A to Z, Ascending or …
220 weergaven3 maanden geleden
YouTubeKbroda Tech
5:14
Excel Split Names Tutorial
576,3K weergaven16 okt. 2017
YouTubeTechnology for Teachers and Students
3:00
Using Custom Sort in Microsoft Excel
20,7K weergaven23 feb. 2023
YouTubeSimon Sez IT
3:28
How to sort data in Excel
31K weergaven15 feb. 2023
YouTubeTechOnTheNet
1:34
How to Sort Alphabetically in Excel
132,7K weergaven15 apr. 2020
YouTubeHow-to Videos
16:51
How to SORT Data in Excel | 7 Tips
153,3K weergaven26 jul. 2022
YouTubeChris Menard
3:38
How to Sort Alphabetically in Excel
655,1K weergaven24 sep. 2019
YouTubeExcel Tutorials by EasyClick Academy
0:11
EXCEL Tricks For Easy Name Sorting
520 weergaven10 maanden geleden
YouTubeThe Positive Peach
13:29
Excel Sorting and Filtering Data
1mln. weergaven7 jun. 2018
YouTubeThe Organic Chemistry Tutor
1:20
How to sort data in Excel | Microsoft
91,7K weergaven18 dec. 2022
YouTubeMicrosoft Helps
8:20
Sorting by Custom Lists in Excel
77,2K weergaven28 aug. 2023
YouTubeTechnology for Teachers and Students
2:56
How to Sort by Date in Excel - ExcelPro
70,9K weergaven11 mei 2019
YouTubeExcel Pro
3:21
How to Separate Names in Excel
393,3K weergaven20 aug. 2019
YouTubeExcel Tutorials by EasyClick Academy
1:16
Excel Pivot Table: How To Sort By Values
98,9K weergaven20 apr. 2022
YouTubeCogwheel Learning
4:00
How to reorder columns in excel | 4 methods
51,8K weergaven29 mrt. 2023
YouTubeKarina Adcock
4:25
How to Separate Names in Excel
209,1K weergaven14 jan. 2020
YouTubeKevin Stratvert
7:38
Sorting in Excel - Basics and Beyond
537,6K weergaven15 nov. 2021
YouTubeTechnology for Teachers and Students
Meer video's bekijken
Statische miniatuurweergave plaatsaanduiding