Скачать или смотреть Sort Full Name by Last Name in Excel | Sort by Last Word in Cell (5 Methods)

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
https://www.paypal.com/donate/?hosted...
Thank you! 👍👍
Download the featured file here: https://www.bluepecantraining.com/wp-...

Download the Power Query add-in https://www.microsoft.com/en-gb/downl...

In this video I demonstrate 5 methods for sorting names where the full name is in a single cell and you want to sort by the last name in the cell (right-most name). This also translates into being able to sort by the last word in cell.

The methods I demonstrate (in order) are:
1) Flash Fill
2) Find and replace
3) Text to columns
4) Power Query
5) Formula, using the SUBSTITUTE, LEN, FIND and MID functions.
=MID(E3,FIND("^",SUBSTITUTE(E3," ","^",LEN(E3)-LEN(SUBSTITUTE(E3," ",""))))+1,LEN(E3))

This video will answer the following queries:
Sort Full Name by Last Name in Excel
Excel sort by last word in cell
Custom sort by last name in Excel
How to sort by last name in Excel when the first is first
How to separate first and last name in Excel
What is the formula to separate first and last name in Excel?
How do you separate names in Excel?
------------------------