Excel help! How to extract homepage domains?

 
Hostwinds

Results 1 to 5 of 5
Hi, I got a list of domains eg. example.com/examplepage I only want a list of ...
  1. #1
    freezeice04's Avatar
    freezeice04 is online now GANGST3R
    Join Date
    Jul 2010
    Location
    AU
    Posts
    646
    Thanks
    233
    Thanked 252 Times in 152 Posts

    Default Excel help! How to extract homepage domains?

    Hi,

    I got a list of domains eg. example.com/examplepage

    I only want a list of the homepage, so in this case that would be example.com

    Is there any way I can extract the bit after the .com using excel?
    [SALE]Thousands of EXPIRED DOMAINS with Good Metrics. PM me if interested: Bulk Buyers ONLY

  2. #2
    Rua999's Avatar
    Rua999 is online now Power Member
    Join Date
    Jun 2011
    Posts
    569
    Thanks
    540
    Thanked 335 Times in 224 Posts
    Blog Entries
    1

    Default Re: Excel help! How to extract homepage domains?

    If you have scrapebox you can do it by using the trim to root function

  3. #3
    gsy159's Avatar
    gsy159 is offline Jr. VIP
    Join Date
    Apr 2011
    Posts
    562
    Thanks
    58
    Thanked 130 Times in 109 Posts

    Default Re: Excel help! How to extract homepage domains?

    there should be a string split function in excel. http://example.com/bla , split that by '/' then you have http: example.com bla and you only take the second

  4. #4
    freezeice04's Avatar
    freezeice04 is online now GANGST3R
    Join Date
    Jul 2010
    Location
    AU
    Posts
    646
    Thanks
    233
    Thanked 252 Times in 152 Posts

    Default Re: Excel help! How to extract homepage domains?

    Quote Originally Posted by Rua999 View Post
    If you have scrapebox you can do it by using the trim to root function
    Don't have scrapebox...

    Quote Originally Posted by gsy159 View Post
    there should be a string split function in excel. http://example.com/bla , split that by '/' then you have http: example.com bla and you only take the second
    Yeah once I split it, then how to I get rid of the second part? The part after the .com?
    [SALE]Thousands of EXPIRED DOMAINS with Good Metrics. PM me if interested: Bulk Buyers ONLY

  5. #5
    freezeice04's Avatar
    freezeice04 is online now GANGST3R
    Join Date
    Jul 2010
    Location
    AU
    Posts
    646
    Thanks
    233
    Thanked 252 Times in 152 Posts

    Default Re: Excel help! How to extract homepage domains?

    Ok I found a solution. For those who also want to know, I just copy and pasted into this website:
    seoweather.com/trim-urls-to-root-domain-standardise-urls-prefixes/
    [SALE]Thousands of EXPIRED DOMAINS with Good Metrics. PM me if interested: Bulk Buyers ONLY

MarketMongoose


SquidProxies

Similar Threads

  1. Replies: 17
    Last Post: 10-31-2014, 09:09 PM
  2. Replies: 2
    Last Post: 03-06-2012, 12:20 PM
  3. Excel: How to extract cell contents based on keywords (HELP)
    By CoyoteAssassin in forum BlackHat Lounge
    Replies: 6
    Last Post: 02-10-2012, 08:36 PM
  4. Replies: 6
    Last Post: 08-13-2011, 08:46 AM
  5. Need Some Excel Macros Made (VBA for Excel)
    By curiosity in forum Hire a Freelancer
    Replies: 5
    Last Post: 11-12-2009, 04:41 AM

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
  •  


 



BlackHatWorld on Twitter BlackHatWorld on FaceBook


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109