Prev: Conditional format question
Next: Look up Data by Row criteria and column criteria
From: Michael on 15 Dec 2009 17:46
Hello,

I'm trying to create some tracking URLs and I am was hoping that there was
an easier way to do this. I have keywords that vary between 2 and 5 words
long. I need to enter unique code before, after and in between each keyword.
I.E.

Apples Oranges Bananas Pears =
code1applescode2orangescode2bananascode2pearscode3 . Is there an easy way I
can create this with a formula?

Thank you for your help,


From: Pete_UK on 15 Dec 2009 19:46
Assuming your text is in A1, try this:

="code1"&SUBSTITUTE(A1," ","code2")&"code3"

and then copy down as required.

Hope this helps.

Pete

On Dec 15, 10:46 pm, Michael <Mich...(a)discussions.microsoft.com>
wrote:
> Hello,
>
> I'm trying to create some tracking URLs and I am was hoping that there was
> an easier way to do this.  I have keywords that vary between 2 and 5 words
> long.  I need to enter unique code before, after and in between each keyword.
>  I.E.
>
> Apples Oranges Bananas Pears =
> code1applescode2orangescode2bananascode2pearscode3 . Is there an easy way I
> can create this with a formula?
>
> Thank you for your help,

 | 
Pages: 1
Prev: Conditional format question
Next: Look up Data by Row criteria and column criteria