Filename format is:
SKU Artist - Songname.mp3
eg. AA1000 THE BEATLES - I FEEL FINE.mp3

I need to split the SKU Artist and songname (without .mp3) and put into their own cells.
I have accomplished the SKU section by using:
=LEFT(A2,6)

I have the songname but having trouble removing the .mp3
=MID(A2,FIND("-",A2)+1,99)

Head spinning too much seperate THE BEATLES

Help appreciated. Thanks