Excel – Get Domain Name From URL

Posted on By David Kittell

This formula will give you a clean base path of a given URL

Example:

URL Just Domain Base Path
http://www.amazon.com/Totally-Free-kindle-Books/lm/R27UG52OAM3TFX amazon.com www.amazon.com 
=IF(ISERROR(FIND("//www.",A2)), MID(A2,FIND(":",A2,4)+3,FIND("/",A2,9)-FIND(":",A2,4)-3), MID(A2,FIND(":",A2,4)+7,FIND("/",A2,9)-FIND(":",A2,4)-7))

=MID(A2,FIND(":",A2,4)+3,FIND("/",A2,9)-FIND(":",A2,4)-3)
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code Excel Microsoft Office

Related Posts

Ubuntu / UNIX – Enable / Disable WiFi

Posted on

nmcli radio wifi off nmcli radio wifi on All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it…

Read More

Mac Terminal – Kill App

Posted on

function KillApp { appname=$1 ps -ax | grep $appname | sed ‘s/^[ \t]*//’ | cut -d " " -f1 | while read -r pid cmd ; do echo "Killing $pid" kill $pid done } KillApp Term All information on this site is shared with the intention to help. Before any…

Read More

Display Second Largest Value

Posted on

SELECT MAX(col) FROM TABLE WHERE col < ( SELECT MAX(col) FROM TABLE ) Originally Posted on June 26, 2014Last Updated on October 26, 2015 All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it…

Read More