Forum Discussion

Marilyn_Wise1215's avatar
Marilyn_Wise1215
Copper Contributor
Oct 07, 2021

Excel four column table in Word 11

 

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.

excel

1 Reply

  • bosinander's avatar
    bosinander
    Iron Contributor
    Oct 08, 2021
    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.

Resources