Hello,

I have a list of songs in one cell as follows:

Number. Song Title - Artist
1. Let the Music Play - Shannon

I would like to extract the number 1 in one cell then Let the Music Play in
another cell then Shannon in another cell.

I would like to create a macro which repeats the process till all the songs
are separate cells.

Please advise how I can do this.

Chris