I have a Word document (attached). For each line I have the Singer as text, then a dash, then the song as a hyperlink. I want to paste these into 2 columns in my Excel file, but if I copy as is from Word it pastes into a single cell with the whole value as a hyperlink.
I'm thinking there should be some kind of Advanced Filter or Text to Columns feature in Word that will allow me to break my document into two columns, one for the artist, one for the hyperlink, which I could then paste into Excel, but I'm not very Word conversant, so can't figure out how to do it. Any help would be appreciated.
Bookmarks