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.