Sub-cell List Sorting
 

I have a book list in Excel. Some of the books have multiple authors listed
in a single cell. Is there a way to sort via the individual authors (not
just the complete list in the single cell) using the "List" feature? I'd
rather not have to put the mutiple authors of a single book each in their own
cell.