1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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:
    209
    Likes Received:
    21
    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,119
    Likes Received:
    656
    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:
    209
    Likes Received:
    21
    Location:
    Croatia
    Thanks mate, you are a life saver :)
     
  4. howard_hughes

    howard_hughes Elite Member

    Joined:
    Jul 23, 2009
    Messages:
    5,048
    Likes Received:
    3,683
    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..