link replace with &

[techwithcoffee]

i have in calc this link in cell formatted as text…

https://www.banggood.com/UMIDIGI-A5-Pro-Global-Version-6_3-Inch-FHD-Waterdro-Display-Android-9_0-4150mAh-Triple-Rear-Cameras-4GB-32GB-Helio-P23-4G-Smartphone-p-1483564.html

i replace .html with this line

?utm_campaign=17092988_tech&utm_content=4083

so it should become

https://www.banggood.com/UMIDIGI-A5-Pro-Global-Version-6_3-Inch-FHD-Waterdro-Display-Android-9_0-4150mAh-Triple-Rear-Cameras-4GB-32GB-Helio-P23-4G-Smartphone-p-1483564.html?utm_campaign=17092988_tech&utm_content=4083

but i get

https://www.banggood.com/UMIDIGI-A5-Pro-Global-Version-6_3-Inch-FHD-Waterdro-Display-Android-9_0-4150mAh-Triple-Rear-Cameras-4GB-32GB-Helio-P23-4G-Smartphone-p-1483564.html?utm_campaign=17092988_tech.htmlutm_content=4083

& turn to .html why???

[mikekaganski]

i replace .html with this line ?utm_campaign=17092988_tech&utm_content=4083

how?

(by the way, edit the question to enclose the links into backticks ``, to let them shown in full, instead of being converted to links and cut to fit)

[robleyd]

I suspect @techwithcoffee is trying to spam the Ask site.

[techwithcoffee]

spam? no this is happening!

[erAck]

I edited the question to show the URLs as code instead of links.

[techwithcoffee]

Got it! it was the Regular expressions option! I removed it and it worked!