Formula Library

Excel Formula To Extract Tld Co.Uk From Domain In Analytics Event Text

Extract top-level domain values from URLs in analytics event text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Quick answer

Extract tld co.uk from domain in analytics event text.

Unified formula

ExcelWPS

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

View platform differences

Google Sheets

=IFERROR(REGEXEXTRACT(A2, "\.([A-Za-z]{2,})(?:/|\?|#|$)"), "")

How it works

Replace the sample range (like A2:A) with your real range.
Keep the same column order used in the example.
Fill down to apply the formula to every row.

Need a custom version?

Related formulas

Excel Formula To Extract Tld Com From Domain In Transaction Text

Extract top-level domain values from URLs in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Extract Tld Net From Domain In Transaction Text

Extract top-level domain values from URLs in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Extract Tld Org From Domain In Transaction Text

Extract top-level domain values from URLs in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Extract Tld Io From Domain In Transaction Text

Extract top-level domain values from URLs in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Extract Tld App From Domain In Transaction Text

Extract top-level domain values from URLs in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Extract Tld Co From Domain In Transaction Text

Extract top-level domain values from URLs in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.