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