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

Attached Files

for excel forum.xlsx (8.4 KB, 6 views)

See the attached.

Replace.xlsx


With Microsoft 365 the formula length can be reduced considerably.

Thanks thatprobably works but it looks a little involved for me, However I t hink I found a way to do this using the text to columns feature so I will close this thread. Thanks again

And when you add data, will you do it all over again? Using XOR's formula in an Excel table will adapt automatically and provide immediate answers

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post