• lestarte

    Hi. Thanks for this. I’d like to add something to the formula, but all data in the “E”-cells are protected by a password. Do you have a link to the original article?
    My idea would be, that we use an additional IF() for the first concat-function.
    Then, the last two-pair-keywords wouldn’t have a space in front of them.
    Just a cosmetical thing, of course.

  • http://www.jlh-marketing.com Jenny Halasz

    Hi lestarte,

    If you want to modify the spreadsheet, the password to unlock it is on the right side of the sheet. If you want to remove a space from a concat-style function, you can either write the formula this way: A1&B1&C1, removing the ” “, or you can use the TRIM function after the fact.

    By the way, this worksheet could have been infinitely more complicated, with nested IF functions for every possible scenario, but my goal was to keep it as simple as possible for people who may not be familiar with excel.

    Hope that helps!

  • http://www.jlh-marketing.com Jenny Halasz

    I should clarify – the formula A1&B1&C1 removes spaces in the middle of the keyword. So [build composite deck] would become [buildcompositedeck]. The TRIM function will remove any extra spaces before or after the keyword, which would happen if you had a value in two out of the three cells and ended up with extra spaces as a result.

  • http://www.franchisenigga.com Gurugi

    But the mods can be handled in another system because there would be a reason for doing it. We’re a bit more dynamic than this illustration but you gave me what I needed to build my garden.

    Thanks, I’ll give you footnote credit when I kill Facebook.

  • http://www.body-buildin.com/ Rhadoo

    Now this is really interesting! I never thought that I could use Excel for my blog :)

  • http://twitter.com/jennyhalasz Jenny Halasz

    Glad you enjoyed it! Thanks for reading. :)

  • xpike_its

    jenny thanks so much its really great info you have shared
    thanks again.

  • http://snapdrawcode.com/ Bibiano Wenceslao

    Awesome writeup Jen! Absolutely helpful, specially for those new to keyword research, and a great refresher as well. For generating somewhat more long-tailed seed keywords using modifiers, I use MergeWords (http://mergewords.com/). Pretty much works the same as your excel function, just with some extra options like a custom separator and term wrapper. ;)


  • http://twitter.com/jennyhalasz Jenny Halasz

    Oh how funny! I had no idea a site like that existed. Still, for some clients, I’d be uncomfortable putting their keywords (especially anything branded) into a web based tool. That’s why I created the one above. I’m probably just paranoid, but I’ve worked for several “top secret” companies!