🔠 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 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
SORT Function
SORT Function
Nov 2, 2023
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…
Jun 7, 2017
tutsplus.com
Separate First and Last Names - Excel & Google Sheets
Separate First and Last Names - Excel & Google Sheets
Sep 7, 2023
automateexcel.com
Sort Names by Last Name in Excel — No Helper Column Needed!
0:35
Sort Names by Last Name in Excel — No Helper Column Needed!
2.5K views1 month ago
YouTubeXLGenAI
Sort names, numbers or dates in #MicrosoftWord 📝 #wordtips #teachertechtip #techtips #edutok #techtok #officetips
Sort names, numbers or dates in #MicrosoftWord 📝 #wordtips #teacher…
31.1K viewsFeb 1, 2021
TikTokmtholfsen
MICROSOFT WORD TIPS: How to sort names in Microsoft Word alphabetica…
556 views1 year ago
TikTokteachersnotebookph
2:12
Microsoft Outlook - Sorting Email
5.5K viewsAug 5, 2015
YouTubeSandor Rethy
5:14
Excel Split Names Tutorial
576.3K viewsOct 16, 2017
YouTubeTechnology for Teachers and Students
1:16
Word Table Sort (descending/ascending/alphabetically)
58.3K viewsSep 3, 2020
YouTubeLeon Renner
1:18
How to Sort a list alphabetically in Microsoft Word 2017
1.9K viewsAug 5, 2017
YouTubePDFEditing
2:21
How To Sort Lists in Microsoft Word
289.5K viewsSep 19, 2011
YouTubenavitend
3:38
How to Sort Alphabetically in Excel
655.1K viewsSep 24, 2019
YouTubeExcel Tutorials by EasyClick Academy
13:29
Excel Sorting and Filtering Data
1M viewsJun 7, 2018
YouTubeThe Organic Chemistry Tutor
3:27
How to Reverse a List in Word
30.5K viewsJun 29, 2019
YouTubeExcel, Word and PowerPoint Tutorials from How…
0:51
How to Alphabetize a List In Microsoft Word
33.8K viewsJul 1, 2017
YouTubeDietcheese
4:25
How to Separate Names in Excel
209.1K viewsJan 14, 2020
YouTubeKevin Stratvert
6:10
How To Sort Names Alphabetically In MS Word by LAST Name!
11.4K viewsDec 19, 2017
YouTubeDavid's Tutorials
3:04
Word How-To: Easily Reorder Items in a List (Shortcut Trick)
28.8K viewsFeb 3, 2016
YouTubeAndyMahnFL411
1:11
How to Sort Excel 2010 by Alphabetical Order
1.2M viewsJan 21, 2013
YouTubeExcel, Word and PowerPoint Tutorials from How…
3:30
How to sort table in Microsoft Word 2010/2013/2016/2019/365 [2020]
30K viewsMay 25, 2020
YouTubePickUpBrain
1:54
How to Change Your User Name for Track Changes in Microsoft Word
178.7K viewsMay 9, 2016
YouTubeErin Wright Writing
3:21
Create a custom list for sorting in Excel by Chris Menard
45.9K viewsMar 22, 2017
YouTubeChris Menard
2:08
How To Arrange Names Alphabetically In Microsoft Word | How To Sort Wor…
51.3K viewsJun 26, 2020
YouTubeFamiHow
1:40
How to sort alphabetically your list of references in Microsoft Word II SAR…
569.5K viewsNov 21, 2014
YouTubeSara Mora
3:53
Word 2016 - Rearrange Pages - How to Move Arrange Change Reorder Sw…
669.2K viewsSep 20, 2017
YouTubeProfessor Adam Morgan
3:03
How To Retain Or Revert Back To Original Sort Order In Excel
206.5K viewsMar 15, 2019
YouTubeExcel Campus - Jon
3:38
Sort Names in the Alphabetical Order Last Names [SORTBY Function]
7.7K viewsMay 2, 2020
YouTubeAjay Anand
14:00
Sort Full Name by Last Name in Excel | Sort by Last Word in Cell (5 Methods)
58.3K viewsJan 25, 2021
YouTubeChester Tugwell
See more videos
Static thumbnail place holder