🔠 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…
312 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
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
Extract Last Name in Excel (5 Easy Ways)
7:02
Extract Last Name in Excel (5 Easy Ways)
Jan 27, 2022
trumpexcel.com
SORT Function
SORT Function
Nov 2, 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)
Jun 30, 2021
trumpexcel.com
Get last name from name
Get last name from name
Oct 26, 2022
exceljet.net
Switch First & Last Names w/ Commas - Excel & Google Sheets
Feb 8, 2023
automateexcel.com
How to Sort Data in Excel Spreadsheets (The Right Way) | E…
Jun 7, 2017
tutsplus.com
0:29
Excel Tricks: How to separate first name and surname from a given f…
102.8K viewsFeb 19, 2023
TikTokletsexcelinexcel
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
0:33
How to Sort Names by Surname in Excel #shorts #education
14 views3 weeks ago
YouTubePeak Productivity Pro
0:38
How to Remove Surname in Excel | Easy Step-by-Step Guide
870 views1 week ago
YouTubeGoogle Sheet Pro
0:58
How to Separate First, Middle and Last Names in Excel #excel #offic…
1.1K views4 weeks ago
YouTubePVC Official
0:14
One Simple Formula to Get Last Name in Excel
1.3K views2 weeks ago
YouTubeComputers Full of Skill
0:59
Paano Magsort ng Data sa Excel ayon sa Apelyido
4.4K viewsAug 28, 2024
TikTokvhietv22
0:34
Extract Last Name with TEXTAFTER Function in Excel - Formula to Spli…
24.2K viewsOct 17, 2022
YouTubeLearn Excel to excel
5:31
HOW TO ARRANGE STUDENT RECORD ACCORING TO NAMES …
258.7K viewsMar 29, 2019
YouTubeThink Technically Era
1:54
How to Remove First Name or Last Name in Microsoft Excel
70 viewsApr 14, 2023
YouTubeBACK-SPACE
5:14
Excel Split Names Tutorial
576.8K viewsOct 16, 2017
YouTubeTechnology for Teachers and Students
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
13:29
Excel Sorting and Filtering Data
1M viewsJun 7, 2018
YouTubeThe Organic Chemistry Tutor
3:21
How to Separate Names in Excel
393.9K viewsAug 20, 2019
YouTubeExcel Tutorials by EasyClick Academy
4:25
How to Separate Names in Excel
209.2K viewsJan 14, 2020
YouTubeKevin Stratvert
0:23
Excel Sort Alphabetically / Alphabetize Column (2020) - 1 MIU…
118K viewsNov 30, 2020
YouTubeLeon Renner
2:19
How to Create Custom Sort List in Excel (Easy Step-by-Step)
82.3K viewsOct 23, 2019
YouTubeTrumpExcel
2:06
How to sort by multiple columns in Excel
297.6K viewsJan 25, 2016
YouTubeBarb Henderson
1:11
How to Sort Excel 2010 by Alphabetical Order
1.2M viewsJan 21, 2013
YouTubeExcel, Word and PowerPoint Tutorials from Ho…
See more videos
Static thumbnail place holder