Convert URLs

In this group there are three buttons: Get Domain, Get SubDomain, and URL Converter.

Text

Description automatically generated with low confidence

Get Domain

A picture containing company name

Description automatically generated

Select cells with URLs to convert and press the button.

Graphical user interface, application, table, Excel

Description automatically generated

Get Subdomain

A picture containing text

Description automatically generated

This button converts URLs to the first-level subdomain. If there is a domain, it leaves it as is.

Graphical user interface, application, table, Excel

Description automatically generated

URL Converter

A picture containing text

Description automatically generated

This button expands a taskpane that offers more options to convert URL to domain or subdomain.

Graphical user interface, application

Description automatically generated

Get Domain options:

example.com – Works the same as button Get Domain.

[www.]example.com – Returns domain with www if present.

Graphical user interface, application, table, Excel

Description automatically generated

http[s]://example.com – Works the same ways as the first option, but this time it keeps http or https if present.

Graphical user interface, application, table, Excel

Description automatically generated

http[s]://[www.]example.com – Works the same ways as the second option, but this time it keeps http or https if present.

Graphical user interface, application, table, Excel

Description automatically generated

Get Subdomain options:

sub1 – Get only the subdomain of the first level. If there is no subdomain present return “-“.

Graphical user interface, application, table, Excel

Description automatically generated

sub2.sub1 – Returns all subdomains is URL. If there is no subdomain, it returns “-“.

Graphical user interface, application, table, Excel

Description automatically generated

sub1.example.com – Returns only the first level subdomain with a domain. If there is no subdomain in the URL, it returns the domain. It works the same way as the subdomain button.

sub2.sub1.example.com – Returns all subdomains with a domain. If there is no subdomain in the URL, it returns the domain.

Graphical user interface, application, table, Excel

Description automatically generated