Excel Formula To Extract Tld Co.Uk From Domain In Support Ticket Text
Extract top-level domain values from URLs in support ticket text with a ready-to-use formula for Excel, Google Sheets, and WPS.
快速答案
统一公式
ExcelWPS
=LET(host,TEXTBEFORE(TEXTAFTER(A2,"//"),"/"), TEXTAFTER(host, ".", -1))查看平台差异
Google Sheets
=IFERROR(REGEXEXTRACT(A2, "\.([A-Za-z]{2,})(?:/|\?|#|$)"), "")使用说明
- 将示例区域（如 A2:A）替换为你的实际区域。
- 保持与示例一致的列顺序。
- 向下填充以应用到所有行。