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: [ Ссылка ]
Free Excel Course - [ Ссылка ]
Paid Online Training - [ Ссылка ]
Best Excel Books: [ Ссылка ]
⚙️ Gear I Recommend:
Camera - [ Ссылка ]
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - [ Ссылка ]
Wireless Mic: [ Ссылка ]
Lighting - [ Ссылка ]
Subscribe to get awesome Excel Tips every week: [ Ссылка ]
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
How to Sort by Last Name in Excel (3 Easy Ways)
Теги
sort by last name in excelsort by last name in ascending order in excelhow to sort by last name in excel when the first is firstexcel sort cells by last name in ascending orderData Sorting in ExcelFind and Replacefind and replace in excelAdvanced FormulasSort names in Excelsort names alphabetically in exceladvanced excelexcel basicsexcel tipsexcel tutorialslearn excelsumit bansaltrump excelmicrosoft excel tutorialmicrosoft excelhow to
