Excel to txt copy

Discussion in 'Black Hat SEO' started by ruicosta, Jan 31, 2012.

  1. ruicosta

    ruicosta Regular Member

    Joined:
    Nov 23, 2009
    Messages:
    210
    Likes Received:
    22
    Location:
    Croatia
    Hey guys!

    I have one excel file with 4 columns. First one is YT username, second is YT pass, third is Yahoo username and fourth is Yahoo pass.

    How can I automaticly extract data from it to txt file to have it in
    YTuser:YTpass format?

    One user/pass combo per line

    thanks
     
  2. Ramsweb

    Ramsweb Senior Member

    Joined:
    Mar 31, 2010
    Messages:
    1,193
    Likes Received:
    689
    Occupation:
    Internet Marketer - Self Employed
    Location:
    In front of my PC
    Cut and paste the last two columns to a separate sheet. Then, for both sheets, do a column to text.

    Use the following link as a guide. They should have covered what you need.

    Code:
    http://www.mrexcel.com/tip074.shtml
     
    • Thanks Thanks x 1
  3. ruicosta

    ruicosta Regular Member

    Joined:
    Nov 23, 2009
    Messages:
    210
    Likes Received:
    22
    Location:
    Croatia
    Thanks mate, you are a life saver :)
     
  4. howard_hughes

    howard_hughes Elite Member

    Joined:
    Jul 23, 2009
    Messages:
    5,057
    Likes Received:
    3,698
    Occupation:
    Just Another Digital Marketer!
    Location:
    "Insta Rank"
    Home Page:
    Copy 1st two columnns and MIcrosoft word file

    You'l get something like this in MIcrosoft word file -

    YTUSERNAME YTPASSWORD

    Then Copy the empty space in between

    find - emptyspacing
    replace all with :

    Result = YTUSERNAME:YTPASSWORD

    Then copy from microsoft word, paste in text:)

    simple..