Let’s see how to extract the domain name from the URL given, extracting the domain name from the URL is one of the most frequent task for those in online and digital marketing.
We will see how we can easily use excel to extract the domain name from the given excel.
We will take the help of Left and Search function in excel.
Use the following function in the cell B2
=LEFT(A2,SEARCH(“/”,A2,9))
As you could see we have the domain available in the cell B2
Also if you would not like to have the suffix “/” at the last in the domain, add a -1 in the formula as shown below.
=LEFT(A2,SEARCH(“/”,A2,9)-1)
The result is shown in cell C2
Hope this helped.