#shorts
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
Watch video #shorts online, duration hours minute second in high quality that is uploaded to the channel My Digital Quill 30 January 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 486 times and liked it 19 visitors.
