Ask Your Question

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

i replace .html with this line


so it should become

but i get

& turn to .html why???

edit retag flag offensive close merge delete


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


(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

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


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

Seen: 24 times

Last updated: Jun 20