Ask Your Question
0

link replace with &

asked 2019-06-20 11:35:15 +0200

updated 2019-06-20 13:47:36 +0200

erAck gravatar image

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???

edit retag flag offensive close merge delete

Comments

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)

Mike Kaganski gravatar imageMike Kaganski ( 2019-06-20 11:56:09 +0200 )edit

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

robleyd gravatar imagerobleyd ( 2019-06-20 12:23:43 +0200 )edit

spam? no this is happening!

techwithcoffee gravatar imagetechwithcoffee ( 2019-06-20 13:45:10 +0200 )edit

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

erAck gravatar imageerAck ( 2019-06-20 13:48:34 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2019-06-20 13:38:36 +0200

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-06-20 11:35:15 +0200

Seen: 24 times

Last updated: Jun 20