A
anonymous
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
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