Need Help

G

Guest

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
 
G

Guest

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

Guest

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

Similar Threads

Ranking and Movement 1
I need help....please!!! 3
Excel Need Countifs Formula Help 0
Help w indices 2
Music in Power Point 2007 4
Convert Time Column to Text 1
Anyhelp 4
Help Ranking 1

Top