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

How can I Sort a list of keyword phrases by the amount of words they have?

Discussion in 'Black Hat SEO' started by daveguy, Jan 14, 2012.

  1. daveguy

    daveguy Power Member

    Joined:
    Nov 22, 2010
    Messages:
    590
    Likes Received:
    251
    Location:
    Florida
    Hello. I have a list of over 5k keywords from the google keyword tool. I'd like to sort my list in excel (or any other program) by word count. Taking something like this:

    17118 17136 17392
    17064 17093 17376
    17118 17136 17356 17318 12345
    17118 17136 17356 17283
    17007 17059 17116
    and sorting it into something like this:

    17118 17136 17356 17318 12345
    17118 17136 17356 17283
    17118 17136 17392
    17064 17093 17376
    17007 17059 17116
    the number represent my keywords. Can anyone help me with this? I am baffled!

    Thanks!
     
  2. nikao

    nikao Power Member

    Joined:
    Oct 14, 2011
    Messages:
    518
    Likes Received:
    180
    Home Page:
    This should do the trick:
    Code:
    =IF(ISBLANK(A1),0,LEN(TRIM(SUBSTITUTE (A1,CHAR(10)," ")))-LEN(SUBSTITUTE (SUBSTITUTE(TRIM(A1),CHAR(10),"")," ",""))+1)
     
    • Thanks Thanks x 1