Can I use this in Google Sheets or WPS?

Yes. Use the Sheets or WPS version shown below. Adjust ranges to match your sheet.

Formula Library

Excel Formula To Extract Subdomain Level 3 From Url In Marketplace Export Text

Paste the formula into the first output cell, then fill down to apply it to your range.

Extract subdomain segments from URLs in marketplace export text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract subdomain level 3 from url in marketplace export text.

ExcelWPS

=LET(host,TEXTBEFORE(TEXTAFTER(A2,"//"),"/"), TEXTBEFORE(host, "."))

View platform differences

=IFERROR(REGEXEXTRACT(A2, "https?://([^.]+)\."), "")

Extract subdomain segments from URLs in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract subdomain segments from URLs in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract subdomain segments from URLs in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract subdomain segments from URLs in imported csv text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract subdomain segments from URLs in imported csv text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract subdomain segments from URLs in imported csv text with a ready-to-use formula for Excel, Google Sheets, and WPS.