'How do I sort data in google sheets by word length?

I was wondering how to sort data in google sheets by how many letters it contains. Could someone help me with this? Please explain clearly as I am new to google sheets.

Thanks.



Solution 1:[1]

use:

=INDEX(SORT(A2:A; LEN(A2:A); 1))

or 0 instead of 1 for reverse ordering

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 player0