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

How do I wrap a list of KW's in () or[] or""?

Discussion in 'White Hat SEO' started by omoxx, Dec 19, 2010.

  1. omoxx

    omoxx Regular Member

    Joined:
    Feb 21, 2008
    Messages:
    346
    Likes Received:
    18
    How do I wrap a list of KW's in () or[] or"", please?

    I tried the function "concatenate" in Excel, but I can't make it
    work for a list of words.:confused:

    Time ago somebody suggested an IM application which performed that, but I do not remember.:confused:

    Thank you
     
  2. wkrappen91

    wkrappen91 Power Member

    Joined:
    Sep 9, 2010
    Messages:
    588
    Likes Received:
    720
    Location:
    127.0.0.1
    What are they seperated by now?
    New line each? if so, it would be easy to do with notepad++
     
  3. antsaoo

    antsaoo Supreme Member

    Joined:
    Oct 1, 2008
    Messages:
    1,291
    Likes Received:
    637
    Well put [ in column 1, keyword in column 2, and ] in column 3. Copy to notepad and use replace. it will be like [(tab)keyword(tab)] so you need only replace tabs with empty :)
     
  4. -Jericho-

    -Jericho- Jr. Executive VIP Jr. VIP Premium Member

    Joined:
    Jan 10, 2010
    Messages:
    2,849
    Likes Received:
    1,704
    Location:
    Stalking My Ex-Wife
    This is what I do to. Is there no easier way to do this. I get so tired of switching between programs to do something that seems like it should be fairly easy to do.
     
  5. omoxx

    omoxx Regular Member

    Joined:
    Feb 21, 2008
    Messages:
    346
    Likes Received:
    18
    Can you explain how to do that with notepad++, please?:(

    Thanxxx
     
  6. ragster

    ragster Newbie

    Joined:
    Nov 17, 2009
    Messages:
    39
    Likes Received:
    18
    Just go here:

    http://tools.seobook.com/ppc-ad-wrapper/

    Then straight to the 'Thanks' button on bottom-right of this post ;)
     
  7. ash134u

    ash134u Junior Member

    Joined:
    Nov 26, 2010
    Messages:
    142
    Likes Received:
    6
    Occupation:
    SEO Expert
    Location:
    India
    Awesome post ! Thanks
     
  8. omoxx

    omoxx Regular Member

    Joined:
    Feb 21, 2008
    Messages:
    346
    Likes Received:
    18
    Suddenly I remembered: the name of the application is "PPCKeywordToolz"

    I found this wonderful site too: jumb*keyword.c*m
     
  9. Velvet

    Velvet Junior Member

    Joined:
    Feb 18, 2009
    Messages:
    199
    Likes Received:
    146
    +1 for that tool

    lot of functions..fast and free

    this is its simplier version
     
  10. TyphoonAgency

    TyphoonAgency Regular Member

    Joined:
    Oct 7, 2010
    Messages:
    280
    Likes Received:
    98
    Occupation:
    Providing professional grade white label SEO servi
    Location:
    Support Ticket System
    I agree it's probably easier to do in notepad or other text editor. Excel just seems incredibly cumbersome. This is the Excel formula I used where A31=blue and A32=green, just as an example. Gotta be easier ways.

    =CONCATENATE("[",A31," AND ",B31," ]")

    [blue AND green]
     
  11. gamingneeds

    gamingneeds Regular Member

    Joined:
    Jul 18, 2008
    Messages:
    401
    Likes Received:
    83
    There was no point in disguising that link. lol