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

Hi guys,

Actually I want to use this tool - https://statically.io/favicons/ which automatically grabs and display favicon of a any website if I write the URL in the format -

https://cdn.statically.io/favicons/domain.com

For example -

https://cdn.statically.io/favicons/google.com

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])

So

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