🔠 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
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
🔠 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 ...
312 views6 days ago
Excel Sorting Tricks
How to SORT Data in Excel | 7 Tips
16:51
How to SORT Data in Excel | 7 Tips
YouTubeChris Menard
149K viewsJul 26, 2022
Ultimate Guide to FILTER, SORT, and SORTBY Functions in Excel: Beginner Tutorial
43:31
Ultimate Guide to FILTER, SORT, and SORTBY Functions in Excel: Beginner Tutorial
YouTubeSimon Sez IT
2.9K views4 months ago
Section 6: Master Sorting, Filters, Tables & Advanced Excel Techniques | Excel Tips & Tricks
1:07:20
Section 6: Master Sorting, Filters, Tables & Advanced Excel Techniques | Excel Tips & Tricks
YouTubePavan Lalwani
11.8K views7 months ago
Top videos
Sort Full Name by Last Name in Excel | Sort by Last Word in Cell (5 Methods)
14:00
Sort Full Name by Last Name in Excel | Sort by Last Word in Cell (5 Methods)
YouTubeChester Tugwell
58.4K viewsJan 25, 2021
Sorting Emails by Domain Name - Excel
4:37
Sorting Emails by Domain Name - Excel
YouTubeMixBernstein
27.8K viewsOct 14, 2019
Sort Email Addresses by Domain Name in Excel
2:30
Sort Email Addresses by Domain Name in Excel
YouTubeYes Excel
2.6K viewsSep 11, 2023
Excel Filter and Sort
Excel Sorting and Filtering Data
13:29
Excel Sorting and Filtering Data
YouTubeThe Organic Chemistry Tutor
1M viewsJun 7, 2018
How to Sort and Filter Your Data in Excel
6:01
How to Sort and Filter Your Data in Excel
YouTubeSimply Excel
53.4K viewsMar 30, 2021
Excel: How to Filter & Sort Data & Columns in Microsoft Excel - Sort A to Z Filter Settings Tutorial
3:51
Excel: How to Filter & Sort Data & Columns in Microsoft Excel - Sort A to Z Filter Settings Tutorial
YouTubeBein' Classy
11.3K viewsOct 8, 2022
Sort Full Name by Last Name in Excel | Sort by Last Word in Cell (5 Methods)
14:00
Sort Full Name by Last Name in Excel | Sort by Last Word in Cell (5 Methods)
58.4K viewsJan 25, 2021
YouTubeChester Tugwell
Sorting Emails by Domain Name - Excel
4:37
Sorting Emails by Domain Name - Excel
27.8K viewsOct 14, 2019
YouTubeMixBernstein
Sort Email Addresses by Domain Name in Excel
2:30
Sort Email Addresses by Domain Name in Excel
2.6K viewsSep 11, 2023
YouTubeYes Excel
Sorting by Custom Lists in Excel
8:20
Sorting by Custom Lists in Excel
74.6K viewsAug 28, 2023
YouTubeTechnology for Teachers and Students
Sort email addresses by domain name in Excel
1:09
Sort email addresses by domain name in Excel
16.1K viewsJan 29, 2022
YouTubeAuditExcel Advanced Excel and Financial Model …
How to Sort a Name List by Same Names in MS Excel : Using Excel & Spreadsheets
1:31
How to Sort a Name List by Same Names in MS Excel : Using Excel & S…
415.8K viewsNov 1, 2013
YouTubeeHowTech
Create Email Address from First and Last Names in Excel
2:40
Create Email Address from First and Last Names in Excel
18.1K viewsSep 4, 2023
YouTubeYes Excel
0:18
How to Sort Names in Ascending Order in Excel - Quick Tutorial | The S…
1.7K viewsJul 7, 2024
YouTubeThe Syntax Writer
7:34
Get First / Last Name and Domain from Email Address 📧+ Create Emails from …
1.8K viewsApr 1, 2024
YouTubeExcel with Rami
2:58
Separate Name and Email Addresses in Excel
11.6K viewsSep 15, 2023
YouTubeYes Excel
10:13
How to Split Names and Emails from a List in Microsoft Excel | FORMULA | F…
8.9K viewsMar 30, 2022
YouTubeRahim Zulfiqar Ali
2:20
Retrieve First And Last Names From Multiple Email Addresses Without An…
10.1K viewsNov 15, 2021
YouTubeThe Excel Hub
0:36
How to Sort Names Alphabetically in Excel Column | Easy Step-by-Step Gu…
4.9K views1 year ago
YouTubeBright Minds Hub
1:00
How do I split first middle and last name in Excel? - Excel Tips and Tricks
3.4K viewsJun 20, 2024
YouTubeRabi Gurung
0:32
How to Extract Last Name in Excel | Last Name | Shorts | Separate First N…
256 viewsMay 23, 2024
YouTubeSystem Tour
5:14
Excel Split Names Tutorial
570.1K viewsOct 16, 2017
YouTubeTechnology for Teachers and Students
2:59
Excel: Switch last name first to first name first
354.6K viewsNov 30, 2011
YouTubejasondenys
19:52
SPLIT NAMES in Excel | Separate First, Middle and Last Name
143.6K viewsSep 26, 2019
YouTubeTrumpExcel
0:50
Extract First, Middle & Last Names from a list of Names in Microsoft Exc…
166.7K viewsJan 14, 2023
YouTubeRahim Zulfiqar Ali
3:24
How To Switch First and Last Name in Excel Column - Swap Last and First N…
128.7K viewsNov 17, 2021
YouTubeSharon Smith
0:36
Separate Names in Excel in 5 SECONDS?! (EASY Excel Trick)
5.7K viewsSep 28, 2024
YouTubeBright Minds Hub
5:50
How to Split full Name to First and Last Name in Excel
362.6K viewsJan 7, 2016
YouTubepc shastra
2:01
Copy email addresses from Outlook to Excel & separate name and address
187.1K viewsJan 16, 2020
YouTubeAuditExcel Advanced Excel and Financial Model …
6:01
How to Sort and Filter Your Data in Excel
53.4K viewsMar 30, 2021
YouTubeSimply Excel
2:40
Excel Automatically generating Email Addresses
92.6K viewsJun 3, 2013
YouTubeJenny Douras
5:42
Convert “First Name Last Name” to “Last Name, First Name” in Excel (Sol…
282.4K viewsDec 1, 2019
YouTubeFrank M. LoSchiavo
1:11
How to Sort Excel 2010 by Alphabetical Order
1.2M viewsJan 21, 2013
YouTubeExcel, Word and PowerPoint Tutorials from How…
0:33
Quickly Create Email Addresses from Names in Excel
64.5K viewsFeb 16, 2023
YouTubeSyncfusion, Inc
0:52
How to Convert Names Into Email Address in Excel
3.2K viewsMar 16, 2022
YouTubeITSolZone
See more videos
Static thumbnail place holder