My Digital Quill | Excel Tips and Tricks #27 | Sort Names by Character Length in Excel | Excel Formulas and Functions | Excel #shorts | Excel shortcuts | Excel 365
This example utilizes a combination of two functions, SORTBY and LEN, to bring sorting order in the list of the name by their character's length. The sorting order can be performed in either ascending or descending order.
This is short sorting trick can enhance the presentability of your data if any other sorting in the data is not important.
Credits:
Thumbnail Photo by Angela Roma from Pexels
Ajay Anand
• Sort by Text Length in Excel
Please check out more Excel tips and tricks from the playlist link down below:
• Excel Tips and Tricks
Check this playlist for Excel formulas and functions:
• Excel Formulas and Functions Series
Free Excel Course available on formatting techniques in here:
• Excel Formatting Techniques
🔔 Subscribe for free Office Tutorials at My Digital Quill:
/ @mydigitalquill8945
#excelshortcuts #Excelformulasandfunctions #Exceltipsandtricks #Excelshorts #excelformattingshortcuts #formattingshortcuts #sortingnamesbytextlength
#MyDigitalQuill
Смотрите видео #shorts онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал My Digital Quill 30 Январь 2022. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 486 раз и оно понравилось 19 посетителям.