How can I separate cell contents at a character?

[JOSHSKORN]

I have a song list that I copied and pasted from a website that looks like this:
Song Title - Artist
So, there's a dash that separates the two. Lets say I have this in Cell A2 (headings in row 1) and in Cells B2 and C2, I want "Song Title" and "Artists", respectively. How can I achieve this?

I would be comfortable using VBA if I have to.

I know I'd have to find the position of the Dash, read before, then after it, then trim the space before and after the dash. I'm just not sure how to do that.

 

[jolivanes]

Copy your text into Cell A1 in an empty sheet and run this snippet to find what the character is.

Sub Get_ASCII_Values_Cell_A1()
    Dim i As Long
    For i = 1 To Len(Range("A1"))
        Cells(i, 2).Value = Mid(Range("A1").Value, i, 1) & "    ="
        Cells(i, 3).Value = Asc(Mid(Range("A1").Value, i, 1))
    Next i
End Sub