Extract Domain from a Cell in Excel
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
Category: MS Excel | Tags: extract, extract domain name, find, mid, MS Excel Comment »