6 {{ upvoteCount | shortNum }}
6 {{ upvoteCount | shortNum }}

How can i add http:// at the begning of a extremely big list?

by legoog8
5 replies
  • SEO
    • |
Hello

I have a massive list of urls that i need to post to and there are millions of them but lol... they are in a format that i cannot use as they havnt got http:// infront of them the are just listed per line.. help please

thank you
#add #begning #big #extremely #http or or #http or or #list
  • Profile picture of the author malcsimm
    Easy! There are several ways. How about this:

    Say you have 10,000 to do.

    Open an Excel spreadsheet and put http:// in A1. Drag it down 10,000 lines. Paste your urls in B1 and down.

    In C1 type in this formula:

    =concatenate (A1,B2)

    Now drag C1 down 10,000 lines. Bingo - now it looks OK, BUT these are forumlae so you cannot copy and paste them. So now you have to make column C NOT be a formula.

    So copy column C into column D, but don't paste it normally, right click in D1 and "paste as values".

    Then you will have the text values in Column D. Copy and paste the urls to where you want them.

    If any of this is unclear Google it and you will find the answer. Or if you are REALLY stuck come back

    ;-)

    Malc
    Signature

    You WILL banish # Procrastination, # Email bloat, # Wasting time, # Wasting money
    Getting Things Done PLUS Evernote turned my life around - read here how I do it
    {{ DiscussionBoard.errors[7620496].message }}
    • Profile picture of the author sanjayyadav
      Originally Posted by malcsimm View Post

      Easy! There are several ways. How about this:

      Say you have 10,000 to do.

      Open an Excel spreadsheet and put http:// in A1. Drag it down 10,000 lines. Paste your urls in B1 and down.

      In C1 type in this formula:

      =concatenate (A1,B2)

      Now drag C1 down 10,000 lines. Bingo - now it looks OK, BUT these are forumlae so you cannot copy and paste them. So now you have to make column C NOT be a formula.

      So copy column C into column D, but don't paste it normally, right click in D1 and "paste as values".

      Then you will have the text values in Column D. Copy and paste the urls to where you want them.

      If any of this is unclear Google it and you will find the answer. Or if you are REALLY stuck come back

      ;-)

      Malc
      It's right and perfect way to do this.
      Signature
      Computer Tech Support | Software Troubleshoot
      {{ DiscussionBoard.errors[7621092].message }}
  • Profile picture of the author legoog8
    thank you i will try that now
    Signature
    Sheffield seo blog
    {{ DiscussionBoard.errors[7620498].message }}
  • Profile picture of the author paulgl
    Originally Posted by legoog8 View Post

    Hello

    I have a massive list of urls that i need to post to and there are millions of them but lol... they are in a format that i cannot use as they havnt got http:// infront of them the are just listed per line.. help please

    thank you
    That's insane. Add to the fact that you have do follow in a sig, and there
    is no such thing as dofollow, makes me wonder.

    Post millions of urls....good luck with that.

    Copy and paste 10,000 into millions? Good luck with that!

    How long would it take a human to post millions of urls?
    Adding http:// would be the least of ones worries.

    Paul
    Signature

    If you were disappointed in your results today, lower your standards tomorrow.

    {{ DiscussionBoard.errors[7621260].message }}
  • Profile picture of the author legoog8
    What? you dont know what i intend to do with these urls after i sort them into their platforms

    and there
    is no such thing as dofollow, makes me wonder.
    Lol.

    Anyway got it all sorted now thanks guys for your help
    Signature
    Sheffield seo blog
    {{ DiscussionBoard.errors[7621332].message }}

Trending Topics