Learn How to Sort by Text Length in Microsoft Excel

The main purpose of this formula is to sort text strings by length in ascending or descending order.

General Formula to Sort by Text Length

=SORTBY(data,LEN(data),-1)

Check Output Country Results