View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michael Michael is offline
external usenet poster
 
Posts: 791
Default Replacing spaces with data from another cell

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,