Sort by text length

Well, the "easy" way would be to add a column next to this column of values, and in the new column put the formula (assuming your data is in column A):

=len(a1)

Fill that down as many rows as needed, then select your data and sort by your LEN column. Once it's sorted you can then delete the column of formulas (or hide it if you think you might need it later).

If you need to run this more than a handful of times, then a macro will be easiest in the long run so you can just press a button and watch it go. I'll defer to others with more vba experience than myself for that part.

Good morning holyearth

If you need to run this more than a handful of times, then a macro will be easiest in the long run so you can just press a button and watch it go. I'll defer to others with more vba experience than myself for that part.

For a ready made solution download and install my add-in from the link below, and go to Ultimate > Range > Sort Range Utility, and select "String length".

HTH

DominicB