Alphabet Lists from Excel

Posted by Tee on June 12, 2001 9:19 PM

Hi One and All

Does anyone know how to and if Excel is able to complie a column of words in alphabetly order under seperate headings. Maybe as a merge doc to Word 7 or in another spreadsheet preferably.

eg.

A
Apple
Ant

B
Boy
Black

C
Crown
Close

Many thanks in advance

Tee.

Posted by Kevin James on June 12, 2001 10:20 PM

Tee:

You can sort your list using Excel's sort function. Thereafter, you can insert blank lines at the beginning of each new alpha character. To speed the insertion of the character you can use =Left(a2,1)

The above formula assumes:
Your first valid data piece is in A2 and therefore A1 will contain the first letter of the item in A2. After that, copy the formula into all other heading cells. The formula will auto-adjust to refer to cell just below it.

Kev