Domain Name Formula

If you want to extract the domain name from a complete url you can do so with a formula that uses the the left and find functions.

Domain name formula. Usually the left function gets a num chars value for the. If it is present in a url. First the left function is used to get the first letter from the first name in column c.

In our example this is dreamhost. Mid a2 find a2 4 3 find a2 9 find a2 4 3 omit www. Overall the most common types of domain names include.

Extract domain name from url function extractdomain byval url as string as string update 20140904 if instr url then url mid url instr url 2 end if if left url 4 like ww ww ww0 9. Extract the domain with www. Therefore we will first explain both functions separately.

This refers to the main part of the url which most commonly contains the name of the website or the business that owns it. In the example we are using this formula. In the first cell of the domain column b2 enter the formula to extract a domain name.

In turn a domain name consists of two primary components. In the generic form above url is the the url you are working with.