🔠 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…
2.5K views3 weeks ago
FacebookExcel By Vikal
Display the Sheet Name in a Cell - Excel Formula | Computergaga
12:45
Display the Sheet Name in a Cell - Excel Formula | Computergaga
Jul 15, 2016
computergaga.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
WEEKNUM Fx - Week Number of Date - Excel, VBA, & G Sheets
15:00
WEEKNUM Fx - Week Number of Date - Excel, VBA, & G Sheets
Nov 6, 2023
automateexcel.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
Get first name from name
Get first name from name
Oct 26, 2022
exceljet.net
Get Worksheet Name from Formula - Excel
Get Worksheet Name from Formula - Excel
Feb 8, 2023
automateexcel.com
Get last name from name
Oct 26, 2022
exceljet.net
Get workbook name only
May 12, 2024
exceljet.net
5:38
How to Fix the Excel Name Error? 3 Simple Tips
Jun 8, 2022
simonsezit.com
WEEKNUM Function
Dec 1, 2023
exceljet.net
How to fix the #NAME? error
Apr 30, 2024
exceljet.net
Using Named Formulas In Excel - Like Yesterday() - Excel TV
Dec 22, 2015
excel.tv
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:42
How to Rename sheet name in Excel #excelremix #spreadsheetmagic #…
481 views1 month ago
YouTubeExcel Remix
7:34
Use Custom Data Types in Excel to simplify your formulas
326 viewsOct 23, 2021
YouTubeFinex Skills Hub
1:52
How to FIX the #NAME ERROR in Excel
1.8K viewsDec 21, 2022
YouTubeLearning Distilled
2:23
🚨 How to solve the #NAME? error in Excel Fromulas
979 viewsOct 25, 2020
YouTubeCogwheel Learning
The Wonderful Excel Feature "Define Name"!
213 views10 months ago
YouTubeStructural Design Only
12:27
SECRET Excel Named Range Shortcuts to Save Time
54.7K viewsApr 28, 2022
YouTubeMyOnlineTrainingHub
0:58
Formula to get Sheet Name in Excel #excelshorts
60K viewsMar 31, 2022
YouTubeAjay Anand
0:21
She asked me to help her pull the last names of specefic names fro…
18.6K viewsJul 31, 2022
TikTokaissaamri
1:42
How to Make Names PROPER in Excel
421 viewsOct 8, 2022
YouTubeExcel by Rob
1:30
Unlocking Excel: How to Dynamically Update Sheet Names …
3 views8 months ago
YouTubevlogize
Master the WEEKDAY Function in Excel | Get the Weekday Name fro…
12 views6 months ago
YouTubeDelft Stack
2:24
The Quickest Way to Create Dynamic Named Ranges In Excel
6.8K viewsAug 21, 2021
YouTubeExcel 10 tutorial
1:00
Tired of messy name formatting in Excel? Here are 4 quick tricks to fi…
1.4K views7 months ago
TikTokleizle.clor
How to Create a Dynamic Names List Based on Status in Excel
7 months ago
YouTube
See more videos
Static thumbnail place holder