Extract Domains From URLs In Excel

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.

Capture

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))

Capture




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

Capture

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply