1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Separate keyword list in notepad with comma

Discussion in 'Products & Tools' started by emelda, Jan 25, 2011.

0
  1. #1
    Hi all,

    Is there such tools that can separate keywords list in notepad format(txt) with commas?

    Example (in notepad):

    make money online
    make money with internet
    how to make money
    fastest way to make money

    Convert to:

    make money online, make money with internet, how to make money, fastest way to make money

    Any suggestion?

    Thanks in advance :D
     
    emelda, Jan 25, 2011 IP
  2. azura123

    azura123 Peon

    Messages:
    7
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    i haven't found way to do this thing in excel. I did it manually, I put my fingers in "," "delete" and "end" lol
     
    azura123, Jan 26, 2011 IP
  3. dtodo

    dtodo Member

    Messages:
    100
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    28
    #3
    using excel, concatenating cells: =a1 &"," & b1 &"," & with all cells.

    Best regards...
     
    dtodo, Jan 26, 2011 IP
  4. emelda

    emelda Peon

    Messages:
    43
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    I got more than 10,000 words :D that's gonna sore.. LOL..
     
    emelda, Jan 26, 2011 IP
  5. emelda

    emelda Peon

    Messages:
    43
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Thanks dtodo, I found the solution already :) more less like what you suggested..
     
    emelda, Jan 26, 2011 IP
  6. tianyaofande

    tianyaofande Peon

    Messages:
    5
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    If you need, I can write one for U.
     
    tianyaofande, Jan 26, 2011 IP
  7. powermatrix

    powermatrix Greenhorn

    Messages:
    9
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #7
    hi could u tell here whats the solution u found out..even i am having the same problem
     
    powermatrix, Jan 28, 2011 IP
  8. emelda

    emelda Peon

    Messages:
    43
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Its quite simple actually. Open your MS excel then follow the follow in the image below:

    [​IMG]

    Formula is =A2&","&A3

    [​IMG]

    Formula is =B3&","&A4

    Then drag the B4 column down - This will automatically put all the commas in place.

    Hope this help :cool:
     
    emelda, Jan 28, 2011 IP
  9. powermatrix

    powermatrix Greenhorn

    Messages:
    9
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #9
    Hi thanks for the lightening fast response , will try it and get to u soon

    cheers
     
    powermatrix, Jan 28, 2011 IP
  10. techbrij

    techbrij Peon

    Messages:
    51
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #10
    You can use Notepad++ and replace '\n' to ','.

    I use Notepad++ for blogging and development. It has all basic features of editor. It is simple and fast.
    See 10+ Notepad++ Tips For Fast Development
     
    techbrij, Feb 9, 2011 IP
  11. thewineman

    thewineman Member

    Messages:
    54
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #11
    Sounds like a great idea and organised
     
    thewineman, Feb 10, 2011 IP