You will need a helper column with =LEN(A1) and fill it down for the list.
Then sort on this column
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"James E Middleton" wrote:

I am looking for a way to sort word lists not alphabetically, but by the
number of letters in each word. (The alphabetical sort can be done after)
Could this be done in Excel?

Is my post OK here, or should I ask in another group?