🔠 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.7K views1 month 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
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 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 Sort Microsoft Excel Columns Alphabetically
How to Sort Microsoft Excel Columns Alphabetically
733.4K views9 months ago
wikiHowEric Wester
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 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 Sort Worksheet Tabs in Alphabetical Order in Excel
Nov 17, 2016
howtogeek.com
How to Split or Reverse First Last Names in Excel
4 months ago
contextures.com
0:58
How to Separate First, Middle and Last Names in Excel #excel #offic…
1.1K views3 weeks ago
YouTubePVC Official
5:31
HOW TO ARRANGE STUDENT RECORD ACCORING TO NAMES …
258.7K viewsMar 29, 2019
YouTubeThink Technically Era
1:27
Sort Excel Worksheets in alphabetical order in 90 seconds
34.9K viewsJan 22, 2018
YouTubeKwikTrix
3:40
How to Alphabetize in Word
219.8K viewsJul 24, 2019
YouTubeKevin Stratvert
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.5K 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.6K viewsAug 20, 2019
YouTubeExcel Tutorials by EasyClick Academy
1:27
Sort alphanumeric data in Excel
27.4K viewsSep 1, 2017
YouTubePrashant Jain
4:25
How to Separate Names in Excel
209.2K viewsJan 14, 2020
YouTubeKevin Stratvert
0:23
Excel Sort Alphabetically / Alphabetize Column (2020) - 1 MIU…
117.5K viewsNov 30, 2020
YouTubeLeon Renner
1:05
How to Sort Excel by Alphabetical Order
4.3K viewsMay 29, 2018
YouTubeHOWZA
3:29
Google Sheets Sort Function | Sort Data in Ascending or Descending …
232.2K viewsNov 5, 2020
YouTubeSoftware Spring
9:17
Randomly Assign Names to Groups - Excel Formula
164.9K viewsAug 21, 2018
YouTubeComputergaga
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
54.9K viewsMar 30, 2021
YouTubeSimply Excel
1:57
Excel Tips 18 - Quickly Sort Data Alphabetically and Numerically in …
294.9K viewsNov 4, 2009
YouTubeTeachExcel
9:00
Reverse First and Last Names in Excel
69.3K viewsMay 25, 2015
YouTubeContextures Inc.
0:53
How to Sort Excel Data in Ascending or Descending Order
234.1K viewsNov 9, 2019
YouTubeFigureAssist
2:47
2 Easy Ways to Separate First & Last Names in Excel
7.1K viewsNov 19, 2020
YouTubeSimple Software Tutorials
See more videos
Static thumbnail place holder