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.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)