create url from text in three different cells

**gymnast46** · 10-26-2007, 02:08 PM

I need to generate a url from three different sources and can't figure out how to do it. I need to create the value in D by combining A, B, and C. Once that's done I need to make the results in D a hard value (not dependent on references from other cells) so I can delete A, B, and C before uploading the spreadsheet to my store. I don't want a formula. I only need to combine plain language entries to create a longer plain language entry. I researched several help sources and the answer is probably right under my nose but I can't find it. Can anyone help me? Contained below is a link to a graphic showing what I'm trying to do.

\1

**sweep** · 10-26-2007, 02:47 PM

Hi,

If I'm reading you right, you just want to string the text together.

To do this, you can use the & operator.

So, in your example, in column D enter =A1&B1&C1

Copy this down the length of your data, then highlight the whole column, and do

Edit > Paste Special > Values

Which will get rid of the formula leaving you with plain text.

**gymnast46** · 10-26-2007, 02:59 PM

Thanks for the prompt reply.

That created exactly the entry I was looking for.

When I tried to "hard wire" the column I tried Edit, Paste Special, but couldn't find VALUES. My choices were "Paste as Unicode Text or Text". Both resulted in error messages saying the stuff on the clipboard was the wrong size.