Need Help

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
 
J

Joel

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

anonymous

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

Joel said:
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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top