🔠 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
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
Get name from email address
Get name from email address
Oct 26, 2022
exceljet.net
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 last name from name
Get last name from name
Oct 26, 2022
exceljet.net
7:02
Extract Last Name in Excel (5 Easy Ways)
Jan 27, 2022
trumpexcel.com
Join first and last name
Nov 25, 2023
exceljet.net
Get first name from name with comma
Nov 20, 2023
exceljet.net
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 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
5:14
Extract First and Last Name & Email Address with TEXTBEFORE and T…
261 views3 months ago
YouTubeExcel at Work
0:38
✅ Excel Shortcut: Split First Name & Last Name with TEXTAFTER
3.4K views2 months ago
YouTubeGUIDE OF MAD - EXCEL
4:32
Extract First, Middle, and Last Name from Full Name in Excel | Advance…
22 views3 weeks ago
YouTubeIT TECH
1:03
How to Separate First & Last Names from Email Addresses in Excel
1 views2 weeks ago
YouTubeArtic Stream
0:22
Create Email ID from First & Last Name in Excel
1.1K views2 months ago
YouTubeMS Excel Funclub
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
Separate First and Last Names from Email Addresses Using Flash Fill
20.8K viewsSep 15, 2022
TikTokexcel_with_kyle
0:23
How to Extract First Name in Excel Using Left and Find Function
33.7K viewsSep 27, 2022
TikTokexcelwithmarkyt
Extract First, Middle & Last Name Without Formulas! (Flash Fill Trick…
357 views9 months ago
TikTokepn_learnexcel
0:55
How to combine first and last names in Excel. To do this we are using t…
1.3K viewsJun 24, 2023
TikTokmodernschoolbus
How to Extract First Name from Email in Excel
132 views7 months ago
YouTubeGradifyX Lab
Excel Tutorial: How to Split Cells with Two Names into Separate Fir…
477 viewsApr 28, 2024
YouTubeVeri Yolculuğu
0:31
Use Excel AI to pull email address into seperate column
67.5K viewsOct 18, 2022
YouTubeAuditExcel Advanced Excel and Financial Mode…
1:00
Get first and last name in Excel-one formula #shorts
10.5K viewsMay 22, 2023
YouTubeExcelMoments
See more videos
Static thumbnail place holder