How would I write a macro that takes a list like this from a variable...
Europe - Rock The Night
Three Days Grace - I Am The Weapon
Sixx-A.M. - Life Is Beautiful
Warrant - Heaven
Syteria - Pause For Peace (Silent Minute)
Girlschool - Don't Mess Around
Velvet Revolver - Fall to Pieces
Dokken - Sleepless Nights
Poison - Talk Dirty to Me
Last In Line - Ghost Town
Bon Jovi - Livin' on a Prayer
Black Stone Cherry - Out Of Pocket
BulletBoys - Smooth Up In Ya
Mötley Crüe - Piece of Your Action
AC/DC - You Shook Me All Night Long
...and returns only the artist names (before the " - ") like this...
Europe
Three Days Grace
Sixx-A.M.
Warrant
Syteria
Girlschool
Velvet Revolver
Dokken
Poison
Last In Line
Bon Jovi
Black Stone Cherry
BulletBoys
Mötley Crüe
AC/DC
?