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.