I am making an obituary index. I have 2 pages of names so far listed in chronological order according to date of death. I decided that it would be more convenient for people using the index if the names were listed in alphabetical order instead.
How do I go back and change the first 2 pages of names from chronological order to alphabetical order?How to list Excel data in alphabetical order after already entering the data in chronological order?If your dates and names are in different columns.
Select the whole data range (all columns) and then Sort on the Name column.
If dates and names are in the same column, you should seperate them into different columns. (And keep them that way, Excel works better with one piece of data per cell).
Text To Columns with a fixed width should work depending on how your data is parsed.
