🔠 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…
406 views1 month ago
FacebookExcel Tricks.
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
Switch First & Last Names w/ Commas - Excel & Google Sheets
Switch First & Last Names w/ Commas - Excel & Google Sheets
Feb 8, 2023
automateexcel.com
How to quickly combine the first and last names in one cell in Excel?
How to quickly combine the first and last names in one cell in Excel?
May 21, 2012
extendoffice.com
How to Separate Names in Excel (Split First and Last)
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
How to Split or Reverse First Last Names in Excel
4 months ago
contextures.com
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
How to split full name to first and last name in Excel?
Jun 8, 2012
extendoffice.com
Get last name from name
Oct 26, 2022
exceljet.net
0:20
Easy Excel Tips: Seperate First and Last Names Quickly
3.1M viewsJan 14, 2023
TikTokexcelogist
How to Sort Data in Excel Spreadsheets (The Right Way) | E…
Jun 7, 2017
tutsplus.com
1:09
Sort data in a range or table in Excel
Oct 28, 2014
Microsoft
0:33
How to Sort Names by Surname in Excel #shorts #education
14 views1 month ago
YouTubePeak Productivity Pro
1:18
Split First and Last Names into Separate Columns #excel , #excelt…
75 views3 weeks ago
YouTubeMATH TECH SHER
3:52
How to Combine First and Last Names in Excel
48 views1 month ago
YouTubeArtic Stream
Excel: Split First and Last Name (Easily!)
6K viewsNov 21, 2022
YouTubeMark's Excel Tips
Automatically Sort Data by Date in Excel
5.9K viewsJan 13, 2021
YouTubemyvid mychannel
How to Combine First and Last Names in Excel: Easy Guide
6 views10 months ago
YouTubeStreamline Tutorial
How to Split Full Name into First Name, Middle Name and Last Nam…
9K viewsNov 10, 2017
YouTubeExcel 10 tutorial
5:14
Excel Split Names Tutorial
577.8K viewsOct 16, 2017
YouTubeTechnology for Teachers and Students
3:18
Sorting Data Randomly In Excel
42.5K viewsJul 29, 2014
YouTubeK2 Enterprises
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.9K viewsSep 24, 2019
YouTubeExcel Tutorials by EasyClick Academy
1:18
How to sort in Excel
3.3K viewsFeb 6, 2020
YouTubeHow-to Videos
13:29
Excel Sorting and Filtering Data
1M viewsJun 7, 2018
YouTubeThe Organic Chemistry Tutor
3:21
How to Separate Names in Excel
394.4K viewsAug 20, 2019
YouTubeExcel Tutorials by EasyClick Academy
1:27
Sort alphanumeric data in Excel
27.4K viewsSep 1, 2017
YouTubePrashant Jain
4:25
How to Separate Names in Excel
208.1K viewsJan 14, 2020
YouTubeKevin Stratvert
2:57
How to Sort and Find duplicates in Excel
127.3K viewsFeb 17, 2009
YouTubeJulie Wolf
6:16
How to Sort and Filter Data in Excel 2016
149.8K viewsMar 5, 2018
YouTubeKnowledgeCity
See more videos
Static thumbnail place holder