🔠 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
SORT Function
SORT Function
2 nov. 2023
exceljet.net
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
How to Sort with a Formula in Excel Using SORT and SORTBY Functions - Excel Campus
How to Sort with a Formula in Excel Using SORT and SORTBY Functions …
5 feb. 2020
excelcampus.com
Sort comma separated values
Sort comma separated values
10 mei 2024
exceljet.net
How to Sort Data in Excel Spreadsheets (The Right Way) | Envato Tuts+
How to Sort Data in Excel Spreadsheets (The Right Way) | Enva…
7 jun. 2017
tutsplus.com
Sort data in a range or table in Excel
1:09
Sort data in a range or table in Excel
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,5K weergaven1 maand geleden
YouTubeXLGenAI
1:12
📊 How to Sort Data in Excel (2025) – Sort Data From A to Z, Ascending or …
220 weergaven3 maanden geleden
YouTubeKbroda Tech
1:46
Stop Manually Organizing Names in Excel! Learn at VedantSri #excel #ve…
250 weergaven3 weken geleden
YouTubeVedantSri
3:58
Excel data sorting, Excel sort function, how to sort data in Excel, Excel sort b…
6 weergaven1 maand geleden
YouTubeExcel & Tally with Dipankar
1:27
Sort Excel Worksheets in alphabetical order in 90 seconds
34,9K weergaven22 jan. 2018
YouTubeKwikTrix
3:42
how to sort names alphabetically using excel
2 weergaven1 maand geleden
YouTubeamour nikka
9:05
MS Excel - Data Sorting
995K weergaven15 jan. 2018
YouTubeTutorialsPoint
5:02
【Excel】SORT関数とSORTBY関数でソートしてみよう
26K weergaven4 mrt. 2022
YouTubePC活用ちゃんねる
2:07
Excel SORT Function | Excel One Minute Functions Explained
93,1K weergaven14 okt. 2021
YouTubeChris Menard
5:14
Excel Split Names Tutorial
576,3K weergaven16 okt. 2017
YouTubeTechnology for Teachers and Students
12:40
Let's sort data using the SORT function! | Improve your work efficien…
6,5K weergaven27 sep. 2023
YouTubeハロー！パソコン教室
3:18
Sorting Data Randomly In Excel
42,5K weergaven29 jul. 2014
YouTubeK2 Enterprises
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,7K weergaven26 jul. 2022
YouTubeChris Menard
3:38
How to Sort Alphabetically in Excel
655,5K weergaven24 sep. 2019
YouTubeExcel Tutorials by EasyClick Academy
0:11
EXCEL Tricks For Easy Name Sorting
520 weergaven10 maanden geleden
YouTubeThe Positive Peach
4:27
Solve Your Sorting Issues In Excel! Part 1
12,7K weergaven16 nov. 2023
YouTubeChris Menard
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,8K weergaven18 dec. 2022
YouTubeMicrosoft Helps
8:20
Sorting by Custom Lists in Excel
77,2K weergaven28 aug. 2023
YouTubeTechnology for Teachers and Students
Meer video's bekijken
Statische miniatuurweergave plaatsaanduiding