Remove https www from domain or URL string in Google Sheets
=trim(REGEXEXTRACT(REGEXREPLACE(REGEXREPLACE(A2;"https?://";"");"^(w{3}\.)?";"")&"/";"([^/?]+)"))

SNAPPED!
=trim(REGEXEXTRACT(REGEXREPLACE(REGEXREPLACE(A2;"https?://";"");"^(w{3}\.)?";"")&"/";"([^/?]+)"))
SEND TO YOURSELF, SAVE FOR LATER, OR SHARE WITH YOUR TEAM!
SNAPPED!
Comments
Post a Comment