🔠 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 Sort Tutorial
Excel for Beginners: Master Cells, Editing, Copying, and Fill Handle Fast
4:28
Excel for Beginners: Master Cells, Editing, Copying, and Fill Handle Fast
YouTubeLearnFree
524 views6 days ago
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
Excel Tutorial for Beginners
16:17
Excel Tutorial for Beginners
YouTubeKevin Stratvert
5.4M viewsJul 25, 2023
Top videos
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
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
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)
trumpexcel.com
Jun 30, 2021
Excel Last Name Sorting
5 Hidden Excel Formula Rules That Make Everything Easier
13:32
5 Hidden Excel Formula Rules That Make Everything Easier
YouTubeMyOnlineTrainingHub
36.2K views5 days ago
🔥 Complete Excel Course: Beginner To Expert | Advanced Excel Tutorial | Excel Training | Simplilearn
10:40:33
🔥 Complete Excel Course: Beginner To Expert | Advanced Excel Tutorial | Excel Training | Simplilearn
YouTubeSimplilearn
325K viewsJul 21, 2023
Microsoft Excel 365 Tutorial: 4-Hour Beginner Excel Training Course
4:22:11
Microsoft Excel 365 Tutorial: 4-Hour Beginner Excel Training Course
YouTubeSimon Sez IT
121.4K viewsDec 5, 2023
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
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
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
Extract Last Name in Excel (5 Easy Ways)
7:02
Extract Last Name in Excel (5 Easy Ways)
Jan 27, 2022
trumpexcel.com
Get first name from name
Get first name from name
Oct 26, 2022
exceljet.net
Join first and last name
Join first and last name
Nov 25, 2023
exceljet.net
Get last name from name
Get last name from name
Oct 26, 2022
exceljet.net
33K views · 170 reactions | Split first, middle and last name in exce…
8.5K views1 week ago
FacebookTime to Office
How to split full name to first and last name in Excel?
Jun 8, 2012
extendoffice.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
15:41
4K views · 67 reactions | How to Extract / Split the First, Middle & L…
4K views1 week ago
FacebookExcel Basement
0:51
Excel_Master on TikTok
Aug 29, 2020
TikTokexcel_master
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
4 months ago
contextures.com
0:15
Combining First and Last Name in Excel: Easy Tutorial!
11.3K viewsFeb 17, 2023
TikTokexcelbyrob
0:11
RIGHT Function | #Excel Formula | Extract Last Name from Full Name
1.1K views2 months ago
YouTubeExcel Sheet Craft
3:52
How to Combine First and Last Names in Excel
3 views2 weeks ago
YouTubeArtic Stream
0:50
How to Join First, Middle and Last Name in Excel #excel #office #spr…
1.6K views3 weeks ago
YouTubePVC Official
0:58
How to Separate First, Middle and Last Names in Excel #excel #offic…
1.1K views3 weeks ago
YouTubePVC Official
0:18
Extract Middle and Last Name in Excel
1.5K views2 months ago
YouTubeNew Tech Mart
0:10
🧹 Remove last names instantly in Excel with Ctrl H #excel #excelfor…
2K views1 month ago
YouTubeSpreadsheet Success
0:16
Extract Last Name in Excel in 5 Seconds! 🔥 | Excel Quick Trick#exc…
8.5K views3 weeks ago
YouTubeMTS computer education🖥️
3:36
Excel Formula to Extract First Name, Last Name & Email Domain | AI wit…
119 views2 months ago
YouTubeGUIDE OF MAD
2:15
TikTok - Make Your Day
121K viewsMay 19, 2024
TikTokdiegotanafranca
0:34
Extract Last Name with TEXTAFTER Function in Excel - Formula to Spli…
24.2K viewsOct 17, 2022
YouTubeLearn Excel to excel
1:56
Excel: Split First and Last Name (Easily!)
6K viewsNov 21, 2022
YouTubeMark's Excel Tips
Extract First, Middle & Last Name Without Formulas! (Flash Fill Trick…
357 views9 months ago
TikTokepn_learnexcel
Extract First and Last Name in Excel using Text functions | Split name…
1.2K viewsDec 12, 2019
YouTubekarpagam Excel Prime
See more videos
Static thumbnail place holder