In this short video, I will show you how to sort your dataset based on the length of the text in the column.
If you’re using a newer version of Excel, you can use the SORTBY function to quickly sort by length of the text in the cells. And in case you’re using an older version that does not have the SORTBY function, you can get this done with a helper column to get the length of the cell and then sort based on that.
00:00 Intro
00:11 Sort by Length Using LEN + Sort feature
01:25 Sort by Length Using the SORTBY feature
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee –
✅ Free Excel Course (Basic to Advanced) –
✅ Free Dashboard Course –
✅ Free VBA course –
✅ Free Power Query Course –
✅ Best Excel Books:
Subscribe to get awesome Excel Tips every week:
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.
Also, I have made all of my Excel courses available for free. You can check these out using the below links:
✅ Free Excel Course (Basic to Advanced) – https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course – https://bit.ly/free-excel-dashboard-course
✅ Free VBA course – https://bit.ly/excel-vba-course
✅ Free Power Query Course – https://bit.ly/power-query-course
Thank you Summit for this great video 📹
Good work Sumit..
SORTBY is powerful. 👍
Hi brother can I get your mail id