Archive of Mr Excel Message BoardArchive of Mr Excel Message Board
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.
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