Tag: extract domain name


Extract Domain from a Cell in Excel

September 14th, 2009 — 4:18pm

If you have a list of urls in a field, how do you get only the domain in excel, strippin goff the “http” as well? Assuming you have a list like this:

http://www.wiseclerk.com/group-news/tag/libor

http://www.wiseclerk.com/group-news/2008/04/

http://www.wiseclerk.com/group-news/

http://www.tiscali.co.uk/search/results.php?section=&from=&query=setana

sports

http://www.techdirt.com/articles/20080408/223932792.shtml

http://www.techdirt.com/articles/20080408/223932792.shtml

http://www.techdirt.com/

http://www.techdirt.com/

http://techdirt.com/index.php

http://techdirt.com/blog.php?tag=loans

and want to extract:
wiseclerk.com
tiscali.co.uk
techdirt.com

=mid(FIELD, 8, FIND("/", FIELD, 8)-8)
should do the trick! Make sure you have a trailing "/"at the end

Comment » | MS Excel

     

↑ Back to top