In this lesson you will learn how to sort words in cells in Excel by character count, eg. from the shortest to the longest.

Excel lets to sort data not only alphabetically but also based on cell colour or font colour. Probably you didn't know but you can also sort based on count of characters. To do this you will need some data. Let the picture below to be the example.

In the B column write formula which refers to value in A column. In B2 formula will be: =LEN(A2)