🔠 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
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
Combine First and Last Names in Excel & Google Sheets
Combine First and Last Names in Excel & Google Sheets
Oct 28, 2023
automateexcel.com
Separate First and Last Names - Excel & Google Sheets
Separate First and Last Names - Excel & Google Sheets
Sep 7, 2023
automateexcel.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
Flip Data in Excel | Reverse Order of Data in Column/Row
10:27
Flip Data in Excel | Reverse Order of Data in Column/Row
Mar 2, 2021
trumpexcel.com
0:18
Merge First & Last Names Easily with CONCATENATE in Excel! 🔠📊✨ …
14.5K views8 months ago
FacebookExcel Formulas Unleashed
8:16
How to Combine First and Last Name in Excel (4 Easy Ways)
Jun 30, 2021
trumpexcel.com
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
3 months ago
contextures.com
Join first and last name
Nov 25, 2023
exceljet.net
How to split full name to first and last name in Excel?
Jun 8, 2012
extendoffice.com
7:15
Reverse Last Name, First Name With Comma Using One Formula: Goog…
Sep 24, 2021
scripteverything.com
Get last name from name
Oct 26, 2022
exceljet.net
0:51
Excel_Master on TikTok
15K viewsAug 29, 2020
TikTokexcel_master
0:20
Easy Excel Tips: Seperate First and Last Names Quickly
3.1M viewsJan 14, 2023
TikTokexcelogist
0:15
Combining First and Last Name in Excel: Easy Tutorial!
11.3K viewsFeb 17, 2023
TikTokexcelbyrob
0:11
⚡ Split full names in Excel instantly with Flash Fill #excel #excelforbeg…
2.1K views1 month ago
YouTubeSpreadsheet Success
0:35
Sort Names by Last Name in Excel — No Helper Column Needed!
2.4K views3 weeks ago
YouTubeXLGenAI
0:58
How to Separate First, Middle and Last Names in Excel #excel #offic…
1.1K views1 week ago
YouTubePVC Official
1:08
Switch First and Last Names in Excel — Quick & Easy Trick!
80 views2 weeks ago
YouTubeExtendOffice
11:31
Excel Lookup Functions – Reverse Lookup Explained | Excel Functio…
151 views2 weeks ago
YouTubeWallStreetMojo
4:28
Replace First and Last Names Excel Tricks
2 months ago
YouTubeExcel Pro 4 Future
Quickly Flip Names in Excel (From First & Last to Last & First)
252 viewsJul 17, 2024
YouTubeExcel Champs
Quickly flip reverse data order of columns or rows in Excel
20 viewsNov 13, 2024
YouTubeExtendOffice
4:08
Reverse Names with Excel MID Function
2.4K viewsApr 9, 2021
YouTubeContextures Inc.
Flip first last names in cells
637 viewsDec 31, 2021
YouTubeExtendOffice
How to Remove Last Name in Excel | 2 Easy Methods (Ctrl+H & Flash Fill)
60 views7 months ago
YouTubeComputer Skills
Splitting Full Names into First, Middle, and Last Names #exceltip…
96 viewsAug 16, 2023
YouTubeCu-li Công Sở
See more videos
Static thumbnail place holder