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
    592
    Thanks
    200
    Thanked 236 Times in 141 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?




  2. #2
    Rua999's Avatar
    Rua999 is online now Power Member
    Join Date
    Jun 2011
    Posts
    513
    Thanks
    516
    Thanked 311 Times in 207 Posts

    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 Power Member
    Join Date
    Apr 2011
    Posts
    544
    Thanks
    58
    Thanked 127 Times in 107 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
    592
    Thanks
    200
    Thanked 236 Times in 141 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?

  5. #5
    freezeice04's Avatar
    freezeice04 is online now GANGST3R
    Join Date
    Jul 2010
    Location
    AU
    Posts
    592
    Thanks
    200
    Thanked 236 Times in 141 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/


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