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

FormatDate Function

Posted on

public string FormatDate(string sDate) { string formatteddate = ""; try { //DateTime d = Convert.ToDateTime(Date); DateTime d = DateTime.Parse(sDate); string format = "MM/dd/yyyy"; formatteddate = d.ToString(format); return formatteddate; } catch { return formatteddate; } } Originally Posted on June 10, 2014Last Updated on October 26, 2015 All information on this…

Read More

XML Reader

Posted on

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Xml; using System.IO; namespace XMLReader1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { string xmlString = "04228911.xml"; XmlDocument doc = new XmlDocument(); doc.Load(@xmlString);…

Read More