Excel Formula To Extract Url Path Depth 1 In Support Ticket Text
Extract URL path information in support ticket text with a ready-to-use formula for Excel, Google Sheets, and WPS.
Quick answer
Unified formula
ExcelWPS
=LET(u,A2, IFERROR(TEXTAFTER(TEXTBEFORE(u, "?"), "//"), u))View platform differences
Google Sheets
=IFERROR(REGEXEXTRACT(A2, "https?://[^/]+(/[^?#]*)"), "/")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.