🔠 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 ...
已浏览 312 次1 个月前
Excel Sort Tutorial
Excel Tutorial for Beginners
16:17
Excel Tutorial for Beginners
YouTubeKevin Stratvert
已浏览 546.2万 次2023年7月25日
Learn Pivot Tables in Excel | Fast & Powerful Data Analysis
2:32
Learn Pivot Tables in Excel | Fast & Powerful Data Analysis
YouTubeIICA Computer Education
已浏览 1.3万 次1 周前
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
已浏览 239.4万 次2021年1月1日
热门视频
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
2020年1月11日
How to SORT in Excel (by Rows, Columns, Colors, Dates, & Numbers)
5:36
How to SORT in Excel (by Rows, Columns, Colors, Dates, & Numbers)
trumpexcel.com
2018年5月16日
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
2019年9月21日
Excel Last Name Sorting
🔥 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
已浏览 32.6万 次2023年7月21日
Learn Microsoft Excel Tutorial For Beginners in UNDER 45 MINUTES! (Microsoft Office 365 Excel)
47:31
Learn Microsoft Excel Tutorial For Beginners in UNDER 45 MINUTES! (Microsoft Office 365 Excel)
YouTubeMyExcelOnline.com
已浏览 15.5万 次2021年3月12日
The Beginner's Guide to Excel - Excel Basics Tutorial
21:47
The Beginner's Guide to Excel - Excel Basics Tutorial
YouTubeTechnology for Teachers and
已浏览 2125.2万 次2017年4月24日
How to Sort by the Last Name in Excel (Easy Guide)
11:52
How to Sort by the Last Name in Excel (Easy Guide)
2020年1月11日
trumpexcel.com
How to SORT in Excel (by Rows, Columns, Colors, Dates, & Numbers)
5:36
How to SORT in Excel (by Rows, Columns, Colors, Dates, & Numbe…
2018年5月16日
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)
2019年9月21日
trumpexcel.com
SORT Function
SORT Function
2023年11月2日
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…
2017年6月7日
tutsplus.com
How to Separate Names in Excel (Split First and Last)
How to Separate Names in Excel (Split First and Last)
2022年12月14日
spreadsheeto.com
How to Split or Reverse First Last Names in Excel
How to Split or Reverse First Last Names in Excel
4 个月之前
contextures.com
1:09
Sort data in a range or table in Excel
2014年10月28日
Microsoft
0:33
How to Sort Names by Surname in Excel #shorts #education
已浏览 14 次3 周前
YouTubePeak Productivity Pro
0:14
One Simple Formula to Get Last Name in Excel
已浏览 1274 次2 周前
YouTubeComputers Full of Skill
5:14
Excel Split Names Tutorial
已浏览 57.7万 次2017年10月16日
YouTubeTechnology for Teachers and Students
1:34
How to Sort Alphabetically in Excel
已浏览 13.3万 次2020年4月15日
YouTubeHow-to Videos
3:38
How to Sort Alphabetically in Excel
已浏览 65.6万 次2019年9月24日
YouTubeExcel Tutorials by EasyClick Academy
13:29
Excel Sorting and Filtering Data
已浏览 101.9万 次2018年6月7日
YouTubeThe Organic Chemistry Tutor
2:56
How to Sort by Date in Excel - ExcelPro
已浏览 7.1万 次2019年5月11日
YouTubeExcel Pro
3:21
How to Separate Names in Excel
已浏览 39.4万 次2019年8月20日
YouTubeExcel Tutorials by EasyClick Academy
4:25
How to Separate Names in Excel
已浏览 20.9万 次2020年1月14日
YouTubeKevin Stratvert
0:23
Excel Sort Alphabetically / Alphabetize Column (2020) - 1 MIU…
已浏览 11.8万 次2020年11月30日
YouTubeLeon Renner
6:16
How to Sort and Filter Data in Excel 2016
已浏览 15万 次2018年3月5日
YouTubeKnowledgeCity
3:29
Google Sheets Sort Function | Sort Data in Ascending or Descending …
已浏览 23.2万 次2020年11月5日
YouTubeSoftware Spring
1:26
How to sort by date in Microsoft excel
已浏览 97.6万 次2016年2月2日
YouTubeSagar S (Vishal)
3:35
How to Quickly Rearrange Column Order in Excel
已浏览 29.2万 次2014年6月9日
YouTubeDanny Rocks
2:19
How to Create Custom Sort List in Excel (Easy Step-by-Step)
已浏览 8.2万 次2019年10月23日
YouTubeTrumpExcel
2:06
How to sort by multiple columns in Excel
已浏览 29.8万 次2016年1月25日
YouTubeBarb Henderson
6:01
How to Sort and Filter Your Data in Excel
已浏览 5.5万 次2021年3月30日
YouTubeSimply Excel
9:00
Reverse First and Last Names in Excel
已浏览 6.9万 次2015年5月25日
YouTubeContextures Inc.
1:03
Delete First Name or Last Name in Excel
已浏览 3万 次2021年5月7日
YouTubeThe Akshay
0:53
How to Sort Excel Data in Ascending or Descending Order
已浏览 23.4万 次2019年11月9日
YouTubeFigureAssist
4:42
How to Combine First and Last Name in Excel
已浏览 57.6万 次2019年10月8日
YouTubeExcel Tutorials by EasyClick Academy
观看更多视频
静态缩略图占位符