How to replaces spaces with + plus signs in excel

October 25, 2005 · 2 comments

in Work

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%

Share and Enjoy:
  • email
  • Digg
  • Reddit
  • StumbleUpon
  • Technorati
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Print

{ 2 comments… read them below or add one }

1 Jonathan 12.22.05 at 10:15 am

SID? CJ?

2 werty 12.22.05 at 12:53 pm

cj is commissionjunction – http://www.cj.com

and SID is their unique tracking codes you can apply to your ads/links. Session ID I am guessing it stand for.

Leave a Comment

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

Previous post:

Next post: