How to extract domain name from URL in Excel
If you want to extract the domain name from a complete URL, you can do so with a formula that uses the LEFT and FIND functions. See example: In the formula below, url is the the URL you are working with. Formula =LEFT(url,FIND(“/”,url,9)) Explanation In the example, we are using this formula: =LEFT(B4,FIND(“/”,B4,9)) Here’s how …