Excel Formula To Extract Tld Dev 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.
Quick answer
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.