Removing & adding characters from multiline cell

[samdinger]

Hi, I am wondering how to remove, in this case, the last 4 or 5 characters from a multiline cell with many links and add/replace new text. So after the jpg I want "?raw=1" instead of dl=0;

Thank you so much beforehand if anyone can answer.
Thank you.

https://www.dropbox.com/s/e6r8epg5yu8hyn/EX001-black-wallet-interior.jpg?dl=0; https://www.dropbox.com/s/4k5nzr63crg767/EX001-black-wallet-features.jpg?dl=0; https://www.dropbox.com/s/5uru1wzupfek3e/EX001-black-wallet-giftbox.jpg?dl=0; https://www.dropbox.com/s/sjffp5md6ux6dt/EX001-black-wallet-front.jpg?dl=0; https://www.dropbox.com/s/788u9yndps1edl/EX001-black-wallet-lifestyle.jpg?dl=0; https://www.dropbox.com/s/0da0nh3hw5bbhr/EX001-black-wallet-lifestyle-2.jpg?dl=0; https://www.dropbox.com/s/pudye9mlz3pf5r/EX001-black-wallet-lifestyle-3.jpg?dl=0

 

[samdinger]

PLeaase help

 

[RoryA]

Can't you just use the Find/Replace dialog and replace dl=0 with raw=1

 

[samdinger]

Can't you just use the Find/Replace dialog and replace dl=0 with raw=1

Thank you for answering!
Could you please type the formula?
I am quite retarded in terms of excel formulas. Thanks again!

 

[RoryA]

I wasn't suggesting a formula. If you want a formula, you'd use SUBSTITUTE:

=SUBSTITUTE(A2,"dl=0","raw=1")

for example.