How to create a URL by adding a slug from other column

Hi guys,

Actually I want to use this tool - which automatically grabs and display favicon of a any website if I write the URL in the format -

For example -

Now, I already have a formula column which has multiple domain URL as the row cell value. Now, I want to create a new column with the following cell structure as shown above.

but here the domain .com should be replaced the domain URL written in that column. Now , what formula should I use to create a URL like this for different values of domain .com

Any help will be appreciated.

Thank you.

Hey, I think you can do this using SUBSTITUTE()

SUBSTITUTE(string, old_text, new_text, [index])


SUBSTITUTE({URL}, "domain", {newdomain})