Is it in Google Sheets?
If so here’s an arrayformula.
={"Shortener";ARRAYFORMULA(IF(A2:A<>"",LEFT(A2:A,FIND(".com/",A2:A)+3),""))}
Is it in Google Sheets?
If so here’s an arrayformula.
={"Shortener";ARRAYFORMULA(IF(A2:A<>"",LEFT(A2:A,FIND(".com/",A2:A)+3),""))}