How do I remove variable length text from multiple cells

I am a bit of an novice, and would like to know, if and how, I can copy a string of text from the end of string in a multiple cells?


cell range A2:A50

Each cell contains the name of an artist and the song title. i.e. “Elvis presley – way down”

I want to copy the text from “-” to the end of the text, and paste it in adjacent column(B2:B50)

Hope I explained it ok.


By: Donald

Leave a Reply

Your email address will not be published. Required fields are marked *