Here’s what we use to turn raw urls into domains (retaining subdomain if there is one):
LEFT(SUBSTITUTE(SUBSTITUTE({URL cell},“http://”,""),“https://”,""),FIND("/",SUBSTITUTE(SUBSTITUTE({URL cell},“http://”,""),“https://”,""))-1)
This removes http(s)...
