How do I sort a word list by length using Excel or some free utility?

Factual Questions
1

I have a list of words in alphabetical order. E.g.:

APPLE
BE
CAT
DOG
HIPPOPOTAMUS
IN

I want to resort it so that it’s sorted by length first, then alphabetically. E.g.:

BE
IN
CAT
DOG
APPLE
HIPPOPOTAMUS

Can I do this using Excel or some other utility that either came with Windows XP or that I can get for free on the Internet (and is easy to use!)?

Thanks in advance.

2

In Excel, you can create a column with the length of the words and sort by that column. For example, if your words are in column A starting in row 1 (‘Apple’ in cell A1), enter the following formula in cell B1:

=len(a1)

That will return 5 for ‘Apple’, 2 for ‘Be’, etc. Copy that formula down the column for the list, and do your sort.

3

Worked like a charm. Thanks.