+ Reply to Thread
Results 1 to 4 of 4

how to convert url to domain name

  1. #1
    Registered User
    Join Date
    06-13-2012
    Location
    paris
    MS-Off Ver
    Excel 2003
    Posts
    3

    how to convert url to domain name

    I am looking for a way to trim link to domain name.And each domain should come once only.

    input:

    http://www.articlesrange.com/article.php?id=13322
    http://media.coloradopatientcoalition.com/article.php?id=63286
    http://www.news.prosurf.com.hr/article.php?id=39
    http://www.news.prosurf.com.hr/article.php?id=37
    http://dailypl.us/1/what-on-earth-has-happened-to-us/
    http://digitword.com/


    output:

    articlesrange.com
    media.coloradopatientcoalition.com
    news.prosurf.com.hr
    dailypl.us
    digitword.com


    Thanks in advance.

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: how to convert url to domain name

    Hi Pepdeal,


    Welcome to the forum

    If you have this data in column A, use below formula in column B and drag down:-

    =MID(A1,8,SEARCH("/",A1,9)-8)

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    06-13-2012
    Location
    paris
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: how to convert url to domain name

    it gives output with www and does not remove duplicate. but it works to filter name.Thanks for this.

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: how to convert url to domain name

    Glad to help you.. Cheers


    Regards,
    DILIPandey

    <click on below 'star' if this helps>

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1