Excel help! How to extract homepage domains?

 

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
    640
    Thanks
    224
    Thanked 249 Times in 150 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
    563
    Thanks
    536
    Thanked 331 Times in 222 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 online now Jr. VIP
    Join Date
    Apr 2011
    Posts
    554
    Thanks
    58
    Thanked 129 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
    640
    Thanks
    224
    Thanked 249 Times in 150 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
    640
    Thanks
    224
    Thanked 249 Times in 150 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


Similar Threads

  1. Replies: 16
    Last Post: 04-17-2014, 08:20 AM
  2. Replies: 2
    Last Post: 03-06-2012, 11:20 AM
  3. Excel: How to extract cell contents based on keywords (HELP)
    By CoyoteAssassin in forum BlackHat Lounge
    Replies: 6
    Last Post: 02-10-2012, 07:36 PM
  4. Replies: 6
    Last Post: 08-13-2011, 07: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, 03: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