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

If your original string is in A1

cell B1
=VALUE(LEFT(A1,FIND(".",A1)-1))
cell C1
=TRIM(MID(A1,FIND(".",A1)+1,(FIND("-",A1)-FIND(".",A1))-1))
Cell D1
=MID(A1,FIND("-",A1)+1,LEN(A1))

"anonymous" wrote:

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

Thank you for your help...it worked out great.

"Joel" wrote:

If your original string is in A1

cell B1
=VALUE(LEFT(A1,FIND(".",A1)-1))
cell C1
=TRIM(MID(A1,FIND(".",A1)+1,(FIND("-",A1)-FIND(".",A1))-1))
Cell D1
=MID(A1,FIND("-",A1)+1,LEN(A1))

"anonymous" wrote:

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