🔠 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.5K views3 weeks ago
Shorts
Did Trump Really Sign Epstein Files Bill? | Pam Bondi's Flip Flop | Sean Duffy's Travel Advice
12:23
2.7M views
Did Trump Really Sign Epstein Files Bill? | Pam Bondi's Flip Flop | Sean
The Late Show with Stephen
who is going to finish this flying obstacle marathon first? the lead flip in second with an comeback
3:00
3.5M views
who is going to finish this flying obstacle marathon first? the lead flip in second
SS FOOD CHALLENGE
Excel Data Flip Tutorial
How to Impress Your Boss at Work: Essential Tips
2:41
How to Impress Your Boss at Work: Essential Tips
TikTokwassif14
10.7M views1 month ago
Excel vali 茶 on Instagram: "Print Excel Sheet on one page  #excelvali #anjnicomputereducation #ExcelForBeginners #excel365tips"
0:27
Excel vali 茶 on Instagram: "Print Excel Sheet on one page  #excelvali #anjnicomputereducation #ExcelForBeginners #excel365tips"
Instagramexcel.vali
2.9M views1 month ago
Master Excel Shortcuts: Beginner to Expert Guide
0:25
Master Excel Shortcuts: Beginner to Expert Guide
TikToksuxiniuri8o
1.3M views1 week ago
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 Separate Names in Excel (Split First and Last)
How to Separate Names in Excel (Split First and Last)
spreadsheeto.com
Dec 14, 2022
Excel Pivot Table
Learn Full Excel course from Basic to Advanced with A.I. | Excel with A.I Masterclass
9:48:18
Learn Full Excel course from Basic to Advanced with A.I. | Excel with A.I Masterclass
YouTubeLearn More
35.4K views2 days ago
The Beginner's Guide to Excel - Excel Basics Tutorial
21:47
The Beginner's Guide to Excel - Excel Basics Tutorial
YouTubeTechnology for Teachers and
21.2M viewsApr 24, 2017
Excel Tutorial for Beginners
16:17
Excel Tutorial for Beginners
YouTubeKevin Stratvert
5.4M viewsJul 25, 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 Separate Names in Excel (Split First and Last)
How to Separate Names in Excel (Split First and Last)
Dec 14, 2022
spreadsheeto.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
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
Join first and last name
Join first and last name
Nov 25, 2023
exceljet.net
How to split full name to first and last name in Excel?
How to split full name to first and last name in Excel?
Jun 8, 2012
extendoffice.com
Get last name from name
Oct 26, 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
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
3 months ago
contextures.com
0:10
🧹 Remove last names instantly in Excel with Ctrl H #excel #excelfor…
1.9K views1 month ago
YouTubeSpreadsheet Success
0:57
Spret First Name & Last Name In Ms Excel | Spret First Name & Last Na…
742 views2 months ago
YouTubePankaj_Education
Quickly Flip Names in Excel (From First & Last to Last & First)
252 viewsJul 17, 2024
YouTubeExcel Champs
1:56
Excel: Split First and Last Name (Easily!)
6K viewsNov 21, 2022
YouTubeMark's Excel Tips
3:09
Split Full Name into First, Middle & Last in Excel | Easy Formula Tricks!
17 views7 months ago
YouTubeBest_Excel
0:54
How to Separate First Name, Middle Name, and Last Name in Excel
56.3K viewsOct 30, 2023
TikTokec.exceltipsandtricks
Extract First and Last Name in Excel using Text functions | Split name…
1.2K viewsDec 12, 2019
YouTubekarpagam Excel Prime
How to Remove Last Name in Excel | 2 Easy Methods (Ctrl+H & Flash Fill)
60 views7 months ago
YouTubeComputer Skills
Excelを使った名前の分割の迅速な方法
862 views10 months ago
TikTokdataanalystofnepal
0:59
Get first and last name in Excel-one formula #shorts
10.5K viewsMay 22, 2023
YouTubeExcelMoments
0:48
How to Separate First Name and Last Name in Excel | Divide Full N…
94 viewsAug 11, 2024
YouTubeLearn with Niaz
How to Combine First and Last Names in Excel: Easy Guide
6 views9 months ago
YouTubeStreamline Tutorial
2:22
How to Split Full Name into First Name, Middle Name and Last Nam…
9K viewsNov 10, 2017
YouTubeExcel 10 tutorial
5:14
Excel Split Names Tutorial
573.5K viewsOct 16, 2017
YouTubeTechnology for Teachers and Students
2:58
Reverse or Flip Data range in Excel
2.9K viewsMar 7, 2021
YouTubeExcelTips
3:21
How to Separate Names in Excel
392.4K viewsAug 20, 2019
YouTubeExcel Tutorials by EasyClick Academy
See more videos
Static thumbnail place holder