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

something to remove keywords with more than x words ?

Discussion in 'Black Hat SEO Tools' started by antsaoo, Nov 20, 2011.

  1. antsaoo

    antsaoo Supreme Member

    Joined:
    Oct 1, 2008
    Messages:
    1,291
    Likes Received:
    637
    As title says. I would need something to remove all keywords from list which have more than x words.

    Thanks
     
  2. satyr85

    satyr85 Power Member

    Joined:
    Aug 7, 2011
    Messages:
    580
    Likes Received:
    445
    Location:
    Poland
    If your list look like:
    cheap adwords
    cheap adwords accounts
    cheap adwords vouchers
    cheap vouchers

    And for example you want to remove keywords with 3 words - i can make it for you for free - just send me kw list via pm. Or if you have some money to spent - i can give you software to do it.
     
  3. dannistone

    dannistone Regular Member

    Joined:
    Aug 7, 2011
    Messages:
    230
    Likes Received:
    103
    Location:
    The Balcans
    I can help for free.
    Paste your keywords in excel. For example in column A. Then go to the top of column B and put in this function: =IF(LEN(TRIM(A1))=0,0,LEN(TRIM(A1))-LEN(SUBSTITUTE(A1," ",""))+1)

    Then just drag it down so that it applies for your full list. This will give you the word count of each cell of column A. Then sort column B (while expanding the sorting for the whole document!) and just delete all rows that contain more words than you want.

    Tadaaaah.
     
    • Thanks Thanks x 1
  4. imguy

    imguy BANNED BANNED

    Joined:
    Jun 25, 2011
    Messages:
    182
    Likes Received:
    191
    Same problem here, anyone know tool or method for this purpose?

    Thanks.
     
  5. jascoken

    jascoken Senior Member

    Joined:
    Nov 1, 2010
    Messages:
    1,135
    Likes Received:
    751
    Gender:
    Male
    Occupation:
    IT/Web Systems & Development...
    Location:
    Sussex:UK
    Just use MS Excel like dannistone says. There are a number of simple ways of displaying the number of words. Just sort and delete those you don't need.
     
  6. imguy

    imguy BANNED BANNED

    Joined:
    Jun 25, 2011
    Messages:
    182
    Likes Received:
    191
    Is there something else?