How to replaces spaces with + plus signs in excel

So I have become kind of an excel power user over the last year or so and have found some crazy shortcuts to save time by using the power of excel to generate spreadsheets for google adwords or overture.

Here is a quick fix to change spaces to + signs in excel so that you can easily use a SID that is unique per keyword from CJ, that way you can track performance per keyword vs per campaign/adgroup:

Set up a spread sheet with:
keyword in column A
your unique landing code in column B (can be the same for all)
and this as column C: =SUBSTITUTE(TRIM(B1&”&SID=”&A1),” “,”+”)

Have fun, make money, send me 20%