🔠 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.7K views1 month ago
Excel Date Functions
Date Functions and Formulas in Excel
5:17
Date Functions and Formulas in Excel
YouTubeTechnology for Teachers and
310.5K viewsApr 11, 2022
Excel Date Functions: Explained with Examples | Training Lesson 6
3:26
Excel Date Functions: Explained with Examples | Training Lesson 6
YouTubeSomeka
737 viewsFeb 21, 2017
How To Use The Date And Time Functions In Microsoft Excel
9:06
How To Use The Date And Time Functions In Microsoft Excel
YouTubeSimon Sez IT
10.9K viewsJun 2, 2022
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
Excel Tutorial for Beginners
16:17
Excel Tutorial for Beginners
YouTubeKevin Stratvert
5.4M viewsJul 25, 2023
Microsoft Excel Tutorial for Beginners | Excel Training | FREE Online Excel course
10:30:00
Microsoft Excel Tutorial for Beginners | Excel Training | FREE Online Excel course
YouTubeProgrammingKnowledge
2.4M viewsJan 1, 2021
🔥 Complete Excel Course: Beginner To Expert | Advanced Excel Tutorial | Excel Training | Simplilearn
10:40:33
🔥 Complete Excel Course: Beginner To Expert | Advanced Excel Tutorial | Excel Training | Simplilearn
YouTubeSimplilearn
325K viewsJul 21, 2023
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
Get name from email address
Get name from email address
Oct 26, 2022
exceljet.net
How to Sort Data in Excel Spreadsheets (The Right Way) | Envato Tuts+
How to Sort Data in Excel Spreadsheets (The Right Way) | E…
Jun 7, 2017
tutsplus.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 Split or Reverse First Last Names in Excel
How to Split or Reverse First Last Names in Excel
4 months ago
contextures.com
1:09
Sort data in a range or table in Excel
Oct 28, 2014
Microsoft
0:33
How to Sort Names by Surname in Excel #shorts #education
14 views2 weeks ago
YouTubePeak Productivity Pro
0:35
Sort Names by Last Name in Excel — No Helper Column Needed!
2.5K views1 month ago
YouTubeXLGenAI
1:12
📊 How to Sort Data in Excel (2025) – Sort Data From A to Z, Ascending …
220 views3 months ago
YouTubeKbroda Tech
1:03
How to Separate First & Last Names from Email Addresses in Excel
1 views3 weeks ago
YouTubeArtic Stream
4:37
Sorting Emails by Domain Name - Excel
27.8K viewsOct 14, 2019
YouTubeMixBernstein
2:12
Microsoft Outlook - Sorting Email
5.5K viewsAug 5, 2015
YouTubeSandor Rethy
5:14
Excel Split Names Tutorial
576.3K viewsOct 16, 2017
YouTubeTechnology for Teachers and Students
1:34
How to Sort Alphabetically in Excel
132.7K viewsApr 15, 2020
YouTubeHow-to Videos
3:38
How to Sort Alphabetically in Excel
655.1K viewsSep 24, 2019
YouTubeExcel Tutorials by EasyClick Academy
13:29
Excel Sorting and Filtering Data
1M viewsJun 7, 2018
YouTubeThe Organic Chemistry Tutor
3:21
How to Separate Names in Excel
393.3K viewsAug 20, 2019
YouTubeExcel Tutorials by EasyClick Academy
4:25
How to Separate Names in Excel
209.1K viewsJan 14, 2020
YouTubeKevin Stratvert
1:05
How to Sort Excel by Alphabetical Order
4.3K viewsMay 29, 2018
YouTubeHOWZA
6:16
How to Sort and Filter Data in Excel 2016
149.6K viewsMar 5, 2018
YouTubeKnowledgeCity
0:54
How to Arrange emails by sender and date in Outlook
151.6K viewsNov 24, 2012
YouTubeExcel, Word and PowerPoint Tutorials from Ho…
2:19
How to Create Custom Sort List in Excel (Easy Step-by-Step)
82.3K viewsOct 23, 2019
YouTubeTrumpExcel
6:01
How to Sort and Filter Your Data in Excel
54.9K viewsMar 30, 2021
YouTubeSimply Excel
1:40
No Formula-Separate First Name & Last Name in MS Excel
346.8K viewsMar 5, 2019
YouTubeMJ Tube
3:12
Take the name from email address in Excel
107.6K viewsFeb 19, 2016
YouTubeBarb Henderson
3:38
Sort Names in the Alphabetical Order Last Names [SORTBY Funct…
7.7K viewsMay 2, 2020
YouTubeAjay Anand
14:00
Sort Full Name by Last Name in Excel | Sort by Last Word in Cell (…
58.3K viewsJan 25, 2021
YouTubeChester Tugwell
See more videos
Static thumbnail place holder