🔠 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 Tricks
Learn Full Excel course from Basic to Advanced with A.I. | Excel with A.I Masterclass
Learn Full Excel course from Basic to Advanced with A.I. | Excel with A.I Masterclass
YouTubeLearn More
189.7K views1 week ago
Mind blowing Excel tricks and tips 🤯 Higlighting target cells, Columns and rows in Excel! Excel tutorials, Excel functions, Excel formula, Excel tips #Excel #exceltips #exceltricks #exceltipsandtricks #ExcelForBeginners #msexceltricks #exceltutorials #msexcel #msexceltips #sheets #excelformula #exceldataentry #AdvanceExcel #spreadsheets | Vision Computers
1:03
Mind blowing Excel tricks and tips 🤯 Higlighting target cells, Columns and rows in Excel! Excel tutorials, Excel functions, Excel formula, Excel tips #Excel #exceltips #exceltricks #exceltipsandtricks #ExcelForBeginners #msexceltricks #exceltutorials #msexcel #msexceltips #sheets #excelformula #exceldataentry #AdvanceExcel #spreadsheets | Vision Computers
FacebookVision Computers
2.2K views1 day ago
5 Hidden Excel Formula Rules That Make Everything Easier
13:32
5 Hidden Excel Formula Rules That Make Everything Easier
YouTubeMyOnlineTrainingHub
30.4K views4 days 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
Separate First and Last Name in Excel (Split Names Using Formulas)
19:52
Separate First and Last Name in Excel (Split Names Using Formulas)
trumpexcel.com
Sep 21, 2019
Find the Last Occurrence of a Lookup Value a List in Excel
15:25
Find the Last Occurrence of a Lookup Value a List in Excel
trumpexcel.com
May 12, 2018
Excel Filter and Sort
Excel for Beginners - The Complete Course
54:55
Excel for Beginners - The Complete Course
YouTubeTechnology for Teachers and
14M viewsAug 22, 2022
Excel Tutorial for Beginners
16:17
Excel Tutorial for Beginners
YouTubeKevin Stratvert
5.4M viewsJul 25, 2023
Microsoft Excel Tutorial for Beginners | Excel Training | FREE Online Excel course
10:30:00
Microsoft Excel Tutorial for Beginners | Excel Training | FREE Online Excel course
YouTubeProgrammingKnowledge
2.4M viewsJan 1, 2021
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
Separate First and Last Name in Excel (Split Names Using Formulas)
19:52
Separate First and Last Name in Excel (Split Names Using Formulas)
Sep 21, 2019
trumpexcel.com
Find the Last Occurrence of a Lookup Value a List in Excel
15:25
Find the Last Occurrence of a Lookup Value a List in Excel
May 12, 2018
trumpexcel.com
Extract Last Name in Excel (5 Easy Ways)
7:02
Extract Last Name in Excel (5 Easy Ways)
Jan 27, 2022
trumpexcel.com
SORT Function
SORT Function
Nov 2, 2023
exceljet.net
Get last name from name
Get last name from name
Oct 26, 2022
exceljet.net
How to sort an Excel Table
How to sort an Excel Table
Oct 27, 2022
exceljet.net
Separate First and Last Names - Excel & Google Sheets
Sep 7, 2023
automateexcel.com
How to quickly combine the first and last names in one cell in Excel?
May 21, 2012
extendoffice.com
Switch First & Last Names w/ Commas - Excel & Google Sheets
Feb 8, 2023
automateexcel.com
How to Sort Data in Excel Spreadsheets (The Right Way) | E…
Jun 7, 2017
tutsplus.com
How to Separate Names in Excel (Split First and Last)
Dec 14, 2022
spreadsheeto.com
0:20
Easy Excel Tips: Seperate First and Last Names Quickly
3.1M viewsJan 14, 2023
TikTokexcelogist
How to Split or Reverse First Last Names in Excel
4 months ago
contextures.com
1:09
Sort data in a range or table in Excel - Microsoft Support
Oct 28, 2014
Microsoft
0:33
How to Sort Names by Surname in Excel #shorts #education
14 views2 weeks ago
YouTubePeak Productivity Pro
0:35
Sort Names by Last Name in Excel — No Helper Column Needed!
2.4K views1 month ago
YouTubeXLGenAI
0:58
How to Separate First, Middle and Last Names in Excel #excel #offic…
1.1K views2 weeks ago
YouTubePVC Official
0:10
🧹 Remove last names instantly in Excel with Ctrl H #excel #excelfor…
1.9K views1 month ago
YouTubeSpreadsheet Success
1:56
Excel: Split First and Last Name (Easily!)
6K viewsNov 21, 2022
YouTubeMark's Excel Tips
How to Remove Last Name in Excel | 2 Easy Methods (Ctrl+H & Flash Fill)
60 views7 months ago
YouTubeComputer Skills
Get last name from name with comma
Oct 26, 2022
exceljet.net
5:14
Excel Split Names Tutorial
568.7K viewsOct 16, 2017
YouTubeTechnology for Teachers and Students
1:34
How to Sort Alphabetically in Excel
132.6K viewsApr 15, 2020
YouTubeHow-to Videos
3:38
How to Sort Alphabetically in Excel
655.1K 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
2:56
How to Sort by Date in Excel - ExcelPro
70.9K viewsMay 11, 2019
YouTubeExcel Pro
3:21
How to Separate Names in Excel
393.3K viewsAug 20, 2019
YouTubeExcel Tutorials by EasyClick Academy
See more videos
Static thumbnail place holder