Shortening a URL

Is it in Google Sheets?

If so here’s an arrayformula.

={"Shortener";ARRAYFORMULA(IF(A2:A<>"",LEFT(A2:A,FIND(".com/",A2:A)+3),""))}
2 Likes