🔠 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
Excel IF Function
How to create a spreadsheet in excel in 5 minutes | excel for beginners
11:54
How to create a spreadsheet in excel in 5 minutes | excel for beginners
YouTubeLearning MsOffice
1.5M viewsJun 3, 2023
Excel初級1（新規作成・画面構成・セルの仕組み・範囲選択）
46:56
Excel初級1（新規作成・画面構成・セルの仕組み・範囲選択）
YouTubeいなわくTV
298.8K viewsSep 10, 2021
Excelの使い方・初心者入門講座【完全版】
1:07:44
Excelの使い方・初心者入門講座【完全版】
YouTube金子晃之
5.2M viewsJan 24, 2020
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
Extract Last Name in Excel (5 Easy Ways)
7:02
Extract Last Name in Excel (5 Easy Ways)
trumpexcel.com
Jan 27, 2022
Split Full Name into First, Middle & Last in Excel | Easy Formula Tricks! Want to extract First Name, Middle Name, and Last Name from a full name in Excel? In this quick tutorial, you'll learn easy and powerful formulas using LEFT, RIGHT, MID, FIND, and SUBSTITUTE — no complex coding or VBA needed! Perfect for Excel beginners and pros who deal with messy name data. Works for: 2-part names (e.g., John Smith) 3-part names (e.g., John Michael Smith) Even single names (e.g., Anjali) Topics Covered:
Split Full Name into First, Middle & Last in Excel | Easy Formula Tricks! Want to extract First Name, Middle Name, and Last Name from a full name in Excel? In this quick tutorial, you'll learn easy and powerful formulas using LEFT, RIGHT, MID, FIND, and SUBSTITUTE — no complex coding or VBA needed! Perfect for Excel beginners and pros who deal with messy name data. Works for: 2-part names (e.g., John Smith) 3-part names (e.g., John Michael Smith) Even single names (e.g., Anjali) Topics Covered:
FacebookExcel Tricks
4.2K views7 months ago
Excel Nested IF
エクセルでコレ 簡単に作れるの知ってる？ #excel #エクセル #pc
1:22
エクセルでコレ 簡単に作れるの知ってる？ #excel #エクセル #pc
YouTubeミナミ‗Excel
42.2K views4 months ago
Excelで表作成に便利なショートカット9選！
1:00
Excelで表作成に便利なショートカット9選！
TikTokacn_shortcut
3.2M views5 months ago
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
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
Split Full Name into First, Middle & Last in Excel | Easy Formula Tricks! Want to extract First Name, Middle Name, and Last Name from a full name in Excel? In this quick tutorial, you'll learn easy and powerful formulas using LEFT, RIGHT, MID, FIND, and SUBSTITUTE — no complex coding or VBA needed! Perfect for Excel beginners and pros who deal with messy name data. Works for: 2-part names (e.g., John Smith) 3-part names (e.g., John Michael Smith) Even single names (e.g., Anjali) Topics Covered:
Split Full Name into First, Middle & Last in Excel | Easy Formula Trick…
4.2K views7 months ago
FacebookExcel Tricks
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
Join first and last name
Join first and last name
Nov 25, 2023
exceljet.net
Get first name from name
Get first name from name
Oct 26, 2022
exceljet.net
Get last name from name
Get last name from name
Oct 26, 2022
exceljet.net
How to quickly combine the first and last names in one cell in Excel?
May 21, 2012
extendoffice.com
Get first name from name with comma
Nov 20, 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
5:14
Extract First and Last Name & Email Address with TEXTBEFORE and T…
261 views3 months ago
YouTubeExcel at Work
22:08
Extract First Name, Middle Name, and Last Name from Full Name in …
2 months ago
YouTubeIT TECH
0:38
✅ Excel Shortcut: Split First Name & Last Name with TEXTAFTER
3.4K views2 months ago
YouTubeGUIDE OF MAD - EXCEL
4:27
How to Separate First and Last Names in Excel
1 views2 weeks ago
YouTubeArtic Stream
4:32
Extract First, Middle, and Last Name from Full Name in Excel | Advance…
22 views3 weeks ago
YouTubeIT TECH
0:18
Extract Day Name From Date in Excel | Excel Formula Trick #rkstu…
4.7K views1 month ago
YouTubeRK Studio 8626
0:24
Excel Magic Tricks | How to Separate First & Last Name in Exc…
981 views2 months ago
YouTubeSharda Computer
0:35
How to extract first, middle and last names in excel 😱 #excel #office #sp…
2 weeks ago
YouTubeTime to Office
0:16
Extract Last Name in Excel in 5 Seconds! 🔥 | Excel Quick Trick#exc…
8.4K views2 weeks ago
YouTubeMTS computer education🖥️
3:36
Excel Formula to Extract First Name, Last Name & Email Domain | AI wit…
119 views2 months ago
YouTubeGUIDE OF MAD
0:11
Extract first character in excel | Use of left Function | Extract initials fr…
82.7K viewsMar 14, 2023
YouTubeData Analyst & Excel
3:15
How to: Extract initials from a cell
10K viewsApr 18, 2013
YouTubeSPTutorials1
Extract First, Middle & Last Name Without Formulas! (Flash Fill Trick…
357 views9 months ago
TikTokepn_learnexcel
0:38
Excel Pro Trick: Extract Initials from Names in Excel using Flash Fill Sh…
31K viewsJan 30, 2023
YouTubeLearn Excel to excel
0:32
Excel Trick# 15 - Separate First & Last Name Formula 02 #shorts #e…
275 views7 months ago
YouTubeFaraz Shaikh
Extract First and Last Name in Excel using Text functions | Split name…
1.2K viewsDec 12, 2019
YouTubekarpagam Excel Prime
1:00
Get first and last name in Excel-one formula #shorts
10.5K viewsMay 22, 2023
YouTubeExcelMoments
How to Split First and Last Names in Excel | Easy Guide
105 views9 months ago
YouTubeHow-To Authority
See more videos
Static thumbnail place holder