Excel four column table in Word 11

Copper Contributor

 

I want to type a name of a song in first column, page number in second column, artist name in third column and date recorded in fourth column.

After they are all entered, I want to sort alphabetical by first letter of the first name in the song that is in the first column.  All the information in the second, third and fourth columns must follow the sort when the name of the song is arranged alphabetically.

Thanks for your help.

1 Reply
Sounds like a fifth, helper column, extracting the first character from first column would do what you want.
Cell E2
=LEFT(A2,1)
Fill down the formula
Select columns E to A and sort by column E.
Copy data rows in column A to D and paste into Word.