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.