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

How to convert .txt text in colums to comma delimited

Discussion in 'Black Hat SEO' started by iglow, Jan 5, 2010.

  1. iglow

    iglow Elite Member

    Joined:
    Feb 20, 2009
    Messages:
    2,081
    Likes Received:
    856
    Home Page:
    okay ive seen that on 1 tutorial somewhere but of course i forgot where and how to do it.
    i have a txt file with lets say 100 words below themselves like:
    aa
    bbb
    ccc
    dddd
    etc

    now i want to make them all in 1 row with "," between:
    aa,bbb,ccc,dddd,etc

    is there some simple way to do that or maybe even small program? i tried googling but seems i cant find right query to find such stuff
     
  2. SEO20

    SEO20 Elite Member

    Joined:
    Mar 25, 2009
    Messages:
    2,017
    Likes Received:
    2,259
    Follow this tut:
    http://office.microsoft.com/en-us/excel/HP052031381033.aspx

    When you have them in cols mark them all. Copy to notepad - replace "tab" with "," and you are done.

    You can also export the data from Excel if you don't want to notepad.
     
    • Thanks Thanks x 1