Skip to main content

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

Reply


Terms & Conditions