How do I use the Excel Formula To Capture Website Host From Link formula?

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

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

Capture website host link with a ready-to-use formula for Excel, Google Sheets, and WPS.

Capture website host link.

ExcelWPS

=LET(url, A2, TEXTBEFORE(TEXTAFTER(url, "//"), "/"))

View platform differences

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

Extract domain a URL with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract domain URL with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract domain URL address with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract domain link with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract domain web address with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract host a URL with a ready-to-use formula for Excel, Google Sheets, and WPS.