Aug 042013
 

If you’re looking to convert many keywords to modified broad, there is an easy way to do it in Excel.  Simply create a new spreadsheet, paste the following line into cell B5, and drag the lower-right corner of that cell down as needed.  The equation is:

=IF(LEN(A5)>0,CONCATENATE(“+”,SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TRIM(A5),”+”,””),”]”,””),”[“,””),””””,””),” “, ” +”)),””)

Now, just enter the keywords you’d like to convert into cells A5 and below, and you will be good to go!

This equation removes quotation marks and square brackets, inserts a plus sign before the first word, and before every word with a space within your keyword.

You can also download a spreadsheet with the equation already loaded.  It’s good for several hundred keywords at a time.