Thank you so much for explaining that for me. It worked perfectly!


vezerid wrote:
Assume your data is in column A:A, say in A2:A10.
Go to another empty column, say column E:E.
In E2 type:

="sterling silver"&A2

Edit/Copy the cell E2. Select E2:E10 and Edit/Paste. Now E2:E10 contain
your new data.

You can either leave it there or replace column A:A. To do so:
Select E2:E10.
Edit/Copy
Select A2
Edit/Paste Special... Check the Values radio button. Click OK.

Now your A2:A10 contain the modified data.

Does this help?
Kostis Vezerides

August wrote:
I hate to ask this, but I'm a complete Excel noob and I honestly don't
know. Where do I put that formula in order to make it work? Sorry for
asking such basic questions, but if I could get this to work it would
save me a lot of time. Thanks for your help.