HDTutorial
EN
How to Sort by Last Name in Excel (3 Easy Ways)

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Sort by Last Name in Excel (3 Easy Ways)

90,418 views January 25, 2020 11:52

Watch on YouTube
ChannelTrumpExcel

Description from the creator

In this video, I will show you three easy ways to sort the names data based on the last name.

The following three methods are covered in this video:
1. Using the Find and Replace technique
2. Using Text to Columns
3. Using Text Formulas

You can also read more about this here: trumpexcel.com/sort-by-last-name-excel/


Free Excel Course - trumpexcel.com/learn-excel/
Paid Online Training - trumpexcel.com/excel-training/
Best Excel Books: trumpexcel.com/best-excel-books/

⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv

Subscribe to get awesome Excel Tips every week: youtube.com/user/trumpexcel?sub_confirmation=1

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

About this tutorial

TrumpExcel published this 11:52 video tutorial on January 25, 2020. It has been watched 90,418 times on YouTube.

Channel
TrumpExcel
Category
Education
Duration
11:52
Published
January 25, 2020
Views
90,418
Likes
666

Tags

Share

Further reading

  • Sort data in a range or table - Excel support.microsoft.com

    To sort by a part of a value in a column, such as a part number code (789-WDG-34), last name (Carol Philips), or first name (Philips, Carol), you first need to split the column into two or more columns so that the value…

  • How to Sort in Excel 2019: Data Lists - dummies dummies.com

    Depending on how you sort Excel to view that list, you may want to see the records in alphabetical order by last name. In the case of a client data table, you may want to see the records arranged alphabetically by compa…

  • How to Sort in Excel - Easy Excel Tutorial excel-easy.com

    To sort on multiple columns, execute the following steps. 1. On the Data tab, in the Sort & Filter group, click Sort. The Sort dialog box appears. 2. Select Last Name from the 'Sort by' drop-down list. 3. Click on Add L…

This tutorial in other languages