Did you mention the filenames with the mp3 extension for a reason? I'm
assuming the first part of your post (no .mp3) is what is in Column A. See
if these formula do what you want...

B1: =TRIM(LEFT(A1, FIND("-",A1)-1))
C1: =TRIM(MID(A1,FIND("-",A1)+1,255))

Rick


"Esra" wrote in message ...
I have a list of file names (Music), the format is "Beatles - Yellow
Submarine" in cells a1 to a10000 (for arguments sake). I want to have
in B1 - Beatles and in C1 - Yellow Submarine.

All files are the same format (Beatles - Yellow Submarine.mp3)

What formulas would I use to get the text to the left of "-" and text
to the right of "-"? Any helpers greatly appreciated

Esra