1. Click on the top cell to the right (or left) of the column you wish to sort.
2. Type "=LEN(" in the function bar and click the first cell of the column you wish to sort. Then add a ")" and hit enter on your keyboard. The full function is "=LEN(cell_ref)". This will reveal the number of characters in the first cell.
3. Click the bottom right corner of the cell with the number and drag down to autofill the rest of the data.
4. Now highlight both columns and click "Sort & Filter" at the top right of the screen. Then click "Sort Smallest to Largest".
5. You can now delete the column with the number of characters.

Download Excel: http://bit.ly/excel-ac

SUPPORT ME

Please consider donating to support the channel: Crypto - http://bit.ly/acamso-crypto​ PayPal - https://bit.ly/acamso-paypal​ Patreon - http://bit.ly/acamso-patreon Buy Me A Tea - http://bit.ly/acamso-tea ... https://www.youtube.com/watch?v=i-rUtHhvLVE