Forum Discussion
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 alphabeti...
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.
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.