How to get the text before and after a hyphen with space on each side of it?

[Asparagus]

Hi. I have a list of songs with the artist name and song name separated by a hyphen (space on both sides of it) and their. Please see enclosed image. With a formula, I would like to separate the artist and song names into two different cells without bringing along the space that follow and proceeds them respectfully.  Is this possible?

[#2 · Accepted solution]

@Asparagus 

If you have Microsoft 365, enter this formula in B2:

=TEXTSPLIT(A2, " - ")

It will spill to C2. Fill down as far as needed.

[#3]

Hehe, awesome!! Thanks so much this save me hours of work.

cheers