🔠 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,
0:35
🔠 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,
2.8K views5 months ago
FacebookExcel By Vikal
Notepad++ sort by name with example
0:22
Notepad++ sort by name with example
4 months ago
humix.com
Sorting Names
1:59
Sorting Names
Sep 19, 2018
teamtreehouse.com
Notepad++ Sort Lines Lexicographically Ascending Descending Order
1:30
Notepad++ Sort Lines Lexicographically Ascending Descending Order
Feb 23, 2023
humix.com
How do I sort alphabetically in OneNote? - TimesMojo
How do I sort alphabetically in OneNote? - TimesMojo
Jul 7, 2022
timesmojo.com
Isaiah Thomas Motivation #motivation #motivational #shorts
0:51
Isaiah Thomas Motivation #motivation #motivational #shorts
321 views2 weeks ago
YouTubeHustler.Mindset
Take mtumba Mtumba business as a full time job and you will enjoy it's fruits. This business can sort all your deepest dreams and achievements Feel inspired @ALICIAS CREME BALES @Aliciasmitumbabales2 #thinkmtumbathinkaliciabales #trending #mitumbabaleskenya #fypシ゚viral
0:10
Take mtumba Mtumba business as a full time job and you will enjoy it's fruits. This business can sort all your deepest dreams and achievements Feel inspired @ALICIAS CREME BALES @Aliciasmitumbabales2 #thinkmtumbathinkaliciabales #trending #mitumbabaleskenya #fypシ゚viral
4.6K views1 month ago
TikTokaliciasbales_gunias
4:31
Excel: Sorting Data
1.1M viewsFeb 8, 2016
YouTubeLearnFree
2:12
Microsoft Outlook - Sorting Email
6K viewsAug 5, 2015
YouTubeSandor Rethy
3:40
How to Alphabetize in Word
223.6K viewsJul 24, 2019
YouTubeKevin Stratvert
1:25:16
Ice Angel (2000) - Full Movie
79.4K viewsMar 13, 2019
YouTubesgillman16
5:14
Excel Split Names Tutorial
593K viewsOct 16, 2017
YouTubeTechnology for Teachers and Students
1:42
Notepad++ Tutorial: Sort Lines/Text (TextFX)
19.3K viewsDec 6, 2016
YouTubeacamso
1:34
How to Sort Alphabetically in Excel
133K viewsApr 15, 2020
YouTubeHow-to Videos
2:21
How To Sort Lists in Microsoft Word
289.7K viewsSep 19, 2011
YouTubenavitend
3:38
How to Sort Alphabetically in Excel
663.6K viewsSep 24, 2019
YouTubeExcel Tutorials by EasyClick Academy
0:51
How to Alphabetize a List In Microsoft Word
33.8K viewsJul 1, 2017
YouTubeDietcheese
3:21
How to Separate Names in Excel
401.3K viewsAug 20, 2019
YouTubeExcel Tutorials by EasyClick Academy
4:25
How to Separate Names in Excel
212.6K viewsJan 14, 2020
YouTubeKevin Stratvert
13:54
C program to SORT NAMES in ALPHABETICAL ORDER | Sorting names in C language
65.9K viewsFeb 9, 2019
YouTubeKrishna Lede
12:16
NOTEPAD++ COLUMN EDIT MODE: Edit Multiple Lines At The Same Time In Notepad++
32.3K viewsJan 26, 2021
YouTubeChris Amit
1:43
EndNote: How to sort your library
6.7K viewsDec 4, 2020
YouTubeResearch Masterminds
6:16
How to Sort and Filter Data in Excel 2016
151.1K viewsMar 5, 2018
YouTubeKnowledgeCity
6:10
How To Sort Names Alphabetically In MS Word by LAST Name!
12K viewsDec 19, 2017
YouTubeDavid's Tutorials
3:04
Word How-To: Easily Reorder Items in a List (Shortcut Trick)
29.3K viewsFeb 3, 2016
YouTubeAndyMahnFL411
5:36
How to Do Multi level sorting in Excel (by two Columns)
214.5K viewsMay 16, 2018
YouTubeTrumpExcel
11:58
Automate Repetitive Task using Notepad++ Macro (With 3 Examples)
23.2K viewsJun 16, 2021
YouTubeChris Amit
1:11
How to Sort Excel 2010 by Alphabetical Order
1.2M viewsJan 21, 2013
YouTubeExcel, Word and PowerPoint Tutorials from Ho…
1:01
C Program to Sort an array of names or strings | GeeksforGeeks
7.1K viewsMar 5, 2018
YouTubeGeeksforGeeks
1:57
Excel Tips 18 - Quickly Sort Data Alphabetically and Numerically in Excel 2007
295.1K viewsNov 4, 2009
YouTubeTeachExcel
See more