🔠 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
Last column number in range
Last column number in range
Aug 15, 2020
exceljet.net
Extract Last Name in Excel (5 Easy Ways)
7:02
Extract Last Name in Excel (5 Easy Ways)
Jan 27, 2022
trumpexcel.com
Lookup Last Value in Column or Row – Excel
Lookup Last Value in Column or Row – Excel
Feb 8, 2023
automateexcel.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
Get last name from name
Oct 26, 2022
exceljet.net
Address of last cell in range
Aug 22, 2021
exceljet.net
Get value of last non-empty cell
Jun 17, 2023
exceljet.net
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:23
How to Combine First & Last Names in Excel #shorts
7.9K views3 weeks ago
YouTubeComputer Tech
0:34
Extract Last Names from Full Name in Excel
794 views1 month ago
YouTubeExcel Training
0:58
How to Separate First, Middle and Last Names in Excel #excel #offic…
1.1K views3 weeks ago
YouTubePVC Official
0:26
Remove Last Names in Excel
1.8K views2 months ago
YouTubeEXCELSIRJI
0:42
Excel formula to find the last number in a Column
22K viewsJul 13, 2021
YouTubeAjay Anand
1:56
Excel: Split First and Last Name (Easily!)
6K viewsNov 21, 2022
YouTubeMark's Excel Tips
2:22
How to Split Full Name into First Name, Middle Name and Last Nam…
9K viewsNov 10, 2017
YouTubeExcel 10 tutorial
Get last name from name with comma
Oct 26, 2022
exceljet.net
5:14
Excel Split Names Tutorial
576.8K viewsOct 16, 2017
YouTubeTechnology for Teachers and Students
6:56
Find the Last Row, Column, or Cell in Excel VBA with the Range.End …
248.7K viewsMay 12, 2015
YouTubeExcel Campus - Jon
4:25
How to Separate Names in Excel
209.2K viewsJan 14, 2020
YouTubeKevin Stratvert
16:10
Google Sheets - Get Last Non-Empty Cell in Row or Column
115.6K viewsOct 14, 2019
YouTubeLearn Google Sheets & Excel Spreadsheets
1:50
How to Change Excel's Column Name : Using Microsoft Excel
386.3K viewsOct 30, 2013
YouTubeeHowTech
1:03
Delete First Name or Last Name in Excel
30.2K viewsMay 7, 2021
YouTubeThe Akshay
4:42
How to Combine First and Last Name in Excel
575.9K viewsOct 8, 2019
YouTubeExcel Tutorials by EasyClick Academy
1:40
No Formula-Separate First Name & Last Name in MS Excel
346.8K viewsMar 5, 2019
YouTubeMJ Tube
0:16
Excel: How to Move to First or Last Row in a List
14K viewsJul 17, 2013
YouTubeFinance Train
24:40
Excel VBA Tutorial: Find the Last Cell, Row or Column on a Worksh…
12.8K viewsJun 20, 2018
YouTubeVictor Chan
See more videos
Static thumbnail place holder