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

Microsoft Azure SQL – Create SQL User

Posted on

In this example I create a Read-Only user but this will work with any access as long as you change the db_datareader access role to what you need In SQL Management Studio open a “New Query” with [master] database USE master GO IF EXISTS ( SELECT * FROM sys.database_principals WHERE…

Read More

Android Contacts – Clear/Remove Notes

Posted on

SELECT data1 FROM data INNER JOIN mimetype ON mimetype_id = mimetypes._id WHERE mimetype LIKE "%note%" AND length(data1) > 0 UPDATE data SET data1 = NULL FROM data INNER JOIN mimetype ON mimetype_id = mimetypes._id WHERE mimetype LIKE "%note%" Originally Posted on December 11, 2013Last Updated on October 26, 2015 All…

Read More

Excel Rand

Posted on

Great if you are creating random passwords, more examples at the reference link below. =CHAR(RANDBETWEEN(65,90))& CHAR(RANDBETWEEN(65,90)) & CHAR(RANDBETWEEN(65,90)) & CHAR(RANDBETWEEN(65,90)) =CHAR(RANDBETWEEN(65,90))& CHAR(RANDBETWEEN(65,90)) & CHAR(RANDBETWEEN(65,90)) & CHAR(RANDBETWEEN(65,90)) & CHAR(RANDBETWEEN(65,90)) & CHAR(RANDBETWEEN(65,90)) & CHAR(RANDBETWEEN(65,90)) & CHAR(RANDBETWEEN(65,90)) Reference: http://excel.tips.net/T003872_Generating_Random_Strings_of_Characters.html Originally Posted on August 11, 2015Last Updated on October 26, 2015 All information on…

Read More