🔠 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 Tricks.
🔠 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 Tricks.. Excel Tricks. · 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 ...
319 views2 weeks ago
Excel Date Functions
How To Fill Numbers In Excel Quickly And Easily!
0:59
How To Fill Numbers In Excel Quickly And Easily!
YouTubeExcel Campus - Jon
1.5M viewsApr 18, 2023
Highlight Active Row and Column in Microsoft Excel
1:10
Highlight Active Row and Column in Microsoft Excel
TikTokfunctional.excel
386.7K views1 week ago
New Excel Feature: Insert Picture In Cell
0:54
New Excel Feature: Insert Picture In Cell
YouTubeExcel Campus - Jon
278.7K viewsJun 6, 2023
Top videos
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
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
Extract Last Name in Excel (5 Easy Ways)
7:02
Extract Last Name in Excel (5 Easy Ways)
trumpexcel.com
Jan 27, 2022
Excel Sort and Filter
Analyze data, build visuals, & write formulas.#excel #microsoftexcel #copilot #microsoft365
0:47
Analyze data, build visuals, & write formulas.#excel #microsoftexcel #copilot #microsoft365
YouTubeMicrosoft Mechanics
2.7K views3 weeks ago
Excel Trick to Count UNIQUE Values in Seconds
1:28
Excel Trick to Count UNIQUE Values in Seconds
YouTubeChandoo
81.9K views1 month ago
Dynamic Drop-down List in Excel using Spill Range & FILTER Function | Smart Data Filtering Tutorial
1:52
Dynamic Drop-down List in Excel using Spill Range & FILTER Function | Smart Data Filtering Tutorial
YouTubeIICA Computer Education
32.5K views1 week ago
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
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
Extract Last Name in Excel (5 Easy Ways)
7:02
Extract Last Name in Excel (5 Easy Ways)
Jan 27, 2022
trumpexcel.com
SORT Function
SORT Function
Nov 2, 2023
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 last name from name
Get last name from name
Oct 26, 2022
exceljet.net
Sort data in a range or table in Excel
Sort data in a range or table in Excel
Oct 28, 2014
Microsoft
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
3 months ago
contextures.com
0:38
✅ Excel Shortcut: Split First Name & Last Name with TEXTAFTER
3.4K views2 months ago
YouTubeGUIDE OF MAD - EXCEL
1:12
📊 How to Sort Data in Excel (2025) – Sort Data From A to Z, Ascending …
220 views2 months ago
YouTubeKbroda Tech
1:22
How To Get Last Letters In MS Excel | Sort Data By Last Characters in …
7.4K viewsOct 21, 2022
YouTubeFamiHow
3:35
MS Excel: How to Sort Value with Data (Large to Small & Ascending …
372.3K viewsJan 17, 2018
YouTubeMJ Tube
9:58
Sorting Lists without messing up the data in Excel
15.8K viewsFeb 18, 2021
YouTubeLearning Break-Simplify Your Work
Get last name from name with comma
Oct 26, 2022
exceljet.net
5:14
Excel Split Names Tutorial
573.5K viewsOct 16, 2017
YouTubeTechnology for Teachers and Students
3:38
How to Sort Alphabetically in Excel
653.8K viewsSep 24, 2019
YouTubeExcel Tutorials by EasyClick Academy
13:29
Excel Sorting and Filtering Data
1M viewsJun 7, 2018
YouTubeThe Organic Chemistry Tutor
2:56
How to Sort by Date in Excel - ExcelPro
70.9K viewsMay 11, 2019
YouTubeExcel Pro
4:25
How to Separate Names in Excel
208.5K viewsJan 14, 2020
YouTubeKevin Stratvert
6:16
How to Sort and Filter Data in Excel 2016
149.4K viewsMar 5, 2018
YouTubeKnowledgeCity
6:10
How To Sort Names Alphabetically In MS Word by LAST Name!
11.2K viewsDec 19, 2017
YouTubeDavid's Tutorials
1:26
How to sort by date in Microsoft excel
976.1K viewsFeb 2, 2016
YouTubeSagar S (Vishal)
3:35
How to Quickly Rearrange Column Order in Excel
291.5K viewsJun 9, 2014
YouTubeDanny Rocks
2:06
How to sort by multiple columns in Excel
297K viewsJan 25, 2016
YouTubeBarb Henderson
1:11
How to Sort Excel 2010 by Alphabetical Order
1.2M viewsJan 21, 2013
YouTubeExcel, Word and PowerPoint Tutorials from Ho…
6:01
How to Sort and Filter Your Data in Excel
53.9K viewsMar 30, 2021
YouTubeSimply Excel
9:00
Reverse First and Last Names in Excel
69.3K viewsMay 25, 2015
YouTubeContextures Inc.
See more videos
Static thumbnail place holder