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.
Many thanks in advance
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.