Organize by prefix and suffix

…So we've taken our keywords and we've looked at them a number of different ways.…However, there's one way that is ultimately the most rewarding way to…divide up your keywords and begin to understand the mind of the searcher.…You see, regardless of your market, regardless of what…kind of business you're in people formulate their searches differently.…And the better you understand the structure and formulation…of those searches, the more apt you will be…to come up with search optimization phrases on your…Website that may not be in the keyword list.…

But the better you understand the structure the more prepared you'll be…to deal with words that you may not have in your keyword research.…But need to be applied on your Site. What I like to do here is divide up my…searches based on the words that come before my keyword and after my keyword.…Here's how I typically do this in a Spreadsheet.…I take my column B of searches and I Copy that and Paste that over in column F.…I'll make column D my centre column and…in here I'm going to put my primary keyword which…