View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Replacing spaces with data from another cell

Check out your other (duplicate) post, and please do not multi-post.

Pete

On Dec 15, 10:44*pm, Michael
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,