00:00i'm going to quickly show you how you can sort by text length in excel if you have a newer
00:04version
00:04of excel keep watching until the end you'll be surprised for those with the older version of
00:09excel here's the way to do it you start off by using a length function i'm going to use this
00:14cell here equal length as in l e n open parenthesis the length function is going to take an argument
00:20of your name data set like this and then close parenthesis and hit enter now you're going to
00:26convert this array of data into a value simply select the array like this ctrl c to copy the
00:34clipboard right click anywhere on this selected cell and then you're going to select as paste as a value
00:40so essentially what this does is that it pastes the data as a value now to do a filtering you're
00:46going
00:46to select the header like this and you press ctrl shift l to enable filtering and basically click on
00:52this pull down and select sort smallest to largest like this and that's how you sort based on text
00:58length you can do it the other way around as well by going here from largest to smallest now if
01:03you
01:03have a newer version of excel you can simply use one formula and then you will get the same result
01:10let
01:10me show you you're going to use a function called sort by and then the first argument in a sort
01:15by would
01:15be your data set range like this and then your second argument we're going to use the same length function
01:22l e and then the argument in the length would be the same data set like this close parenthesis twice
01:30and hit enter as you can see it'll give you in ascending orders similar result to what you've seen
01:35just now but if you want in descending order simply put the third argument as minus one and then you
01:43get
01:43it in descending order
