I have a karaoke song list (8000 songs) which is stupidly contained in one column in excel. it is formatted as follows
folder-#-title-artist
I need to separate into three columns
Folder-#, Title, Artist
I have figured out how to extract the title and artist from the string.
I have found many formulas for grabbing text before and after hyphens, but not for extracting text before a second hyphen.
EXAMPLE
CURRENTLY
BK-01 - A MILLION WAYS TO FALL - BOBBY UK
NEED
BK-01
Bookmarks