Can replace function be used with wildcards?
Hi folks. I am looking for help from the Excel wizards to quickly edit some cells. Please see attached apreadsheet for what I want to do. I could edit these rows manually but its a long long list of songs and that would be very time comsuming. There's probably a way to do this with the replace function and using wildcards, but I dont know how. Please advise if this can be done automatically. I want to take the song title in every row and remove the preceeding number that exists as well as the number in brackets at the end which is the nength of the song, so I am left with just the title of the song. If I cant do this using replace function and wildcards can UI generate some sort of macro that will work? Many thanks
|