🔠 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,
FacebookExcel By Vikal
🔠 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
Excel By Vikal. Excel By Vikal · Original audio. 🔠 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 ...
2.7K views1 month ago
Excel Sorting Tutorial
Sorting in Excel - Basics and Beyond
7:38
Sorting in Excel - Basics and Beyond
YouTubeTechnology for Teachers and
539.7K viewsNov 15, 2021
Excel: Sorting Data
4:31
Excel: Sorting Data
YouTubeLearnFree
1.1M viewsFeb 8, 2016
How to Quickly Sort Data in Excel | Excel Tips for Beginners
4:23
How to Quickly Sort Data in Excel | Excel Tips for Beginners
YouTubeThe IT Academy
1K views6 months ago
Top videos
How to Sort by the Last Name in Excel (Easy Guide)
11:52
How to Sort by the Last Name in Excel (Easy Guide)
trumpexcel.com
Jan 11, 2020
SORT Function
SORT Function
exceljet.net
Nov 2, 2023
Getting ready to send a sleigh full of gifts, holiday cards, party invitations, or thank-you notes?🎁❄️ Manage all your mailing addresses in an Excel spreadsheet. http://msft.it/6188TVEUK | Microsoft Excel
1:30
Getting ready to send a sleigh full of gifts, holiday cards, party invitations, or thank-you notes?🎁❄️ Manage all your mailing addresses in an Excel spreadsheet. http://msft.it/6188TVEUK | Microsoft Excel
FacebookMicrosoft Excel
16.5K viewsDec 3, 2019
Excel Spreadsheet Tips
50 Ultimate Excel Tips and Tricks for 2020
50:17
50 Ultimate Excel Tips and Tricks for 2020
YouTubeSele Training
1.9M viewsMar 17, 2020
30 Essential Excel Tips and Tricks for 2024 - Excel Productivity Tutorial
2:07:11
30 Essential Excel Tips and Tricks for 2024 - Excel Productivity Tutorial
YouTubeSimon Sez IT
99.5K viewsJan 9, 2024
31 Excel Tricks that everyone should know!
45:38
31 Excel Tricks that everyone should know!
YouTubeLearn More
149.3K viewsDec 5, 2024
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
Getting ready to send a sleigh full of gifts, holiday cards, party invitations, or thank-you notes?🎁❄️ Manage all your mailing addresses in an Excel spreadsheet. http://msft.it/6188TVEUK | Microsoft Excel
1:30
Getting ready to send a sleigh full of gifts, holiday cards, party invitatio…
16.5K viewsDec 3, 2019
FacebookMicrosoft Excel
How to Sort Data in Excel Spreadsheets (The Right Way) | Envato Tuts+
How to Sort Data in Excel Spreadsheets (The Right Way) | E…
Jun 7, 2017
tutsplus.com
Sort data in a range or table in Excel
1:09
Sort data in a range or table in Excel
Oct 28, 2014
Microsoft
Excel 2016: Sorting Data
Excel 2016: Sorting Data
Jan 1, 2009
gcfglobal.org
Sort Addresses by Distance from Target Location
1:03
Sort Addresses by Distance from Target Location
1.4K views1 month ago
YouTubeExcel Distance Calculators
0:33
Sort Names by Length in Excel in Seconds! | Simple Excel Trick Yo…
25 views1 month ago
YouTubeMalzTech
2:48
How Do I Sort Excel Data By Row (left To Right)? - Docs and Sheets …
2 months ago
YouTubeDocs and Sheets Pro
1:12
📊 How to Sort Data in Excel (2025) – Sort Data From A to Z, Ascending …
220 views3 months ago
YouTubeKbroda Tech
How to Find Specific Street Names Using Certain Keywords in Excel
6 views7 months ago
YouTubeExcel Primed
5:17
Excel Advanced Sorting Options
23.2K viewsDec 18, 2013
YouTubeIQ Accounting Solutions
5:14
Excel Split Names Tutorial
576.8K viewsOct 16, 2017
YouTubeTechnology for Teachers and Students
0:50
Create a Map from Excel Spreadsheet Locations
141.1K viewsSep 26, 2015
YouTubeMapline
5:31
Formatting Addresses in Excel Worksheets
20.6K viewsNov 2, 2020
YouTubeProfessor Tanaka
1:34
How to Sort Alphabetically in Excel
132.7K viewsApr 15, 2020
YouTubeHow-to Videos
2:57
How to Custom Sort in Excel - Tutorial
47.3K viewsMay 14, 2018
YouTubeExcel Tutorials by Y. Acosta
3:38
How to Sort Alphabetically in Excel
655.5K viewsSep 24, 2019
YouTubeExcel Tutorials by EasyClick Academy
10:59
How to Map Addresses From an Excel Spreadsheet
5.7K viewsFeb 7, 2017
YouTubeMango Map
13:29
Excel Sorting and Filtering Data
1M viewsJun 7, 2018
YouTubeThe Organic Chemistry Tutor
8:53
Transfer Microsoft Word Addresses to Excel Spreadsheet
42.3K viewsFeb 15, 2014
YouTubeKirk Downing
13:47
How To Separate Addresses In Excel From One Column To Four
55.7K viewsAug 31, 2016
YouTubeLarissa Fontenot
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
4:22
How To...Sort Data in Excel 2010
444.3K viewsOct 26, 2010
YouTubeEugene O'Loughlin
6:16
How to Sort and Filter Data in Excel 2016
149.6K viewsMar 5, 2018
YouTubeKnowledgeCity
5:14
How to separate, City, State and Zip Code in Excel
14.5K viewsMar 29, 2018
YouTubeInvestor Ninjas
5:57
Excel - Sort Unorganized Data (rows and columns together)
5.1K viewsJun 2, 2014
YouTubeJalayer Academy
3:33
How To Sort Based on Multiple Columns in Excel
12.6K viewsJul 18, 2021
YouTubeExcel 10 tutorial
See more videos
Static thumbnail place holder