Adding something to a column

A

August

I need to add Sterling Silver to the front of every item in a column.
Is this possible to do through a function, or do I need to do it
manually? Here's an example of what I need:

They look like this now

a
b
c

I need them to look like this

sterling silver a
sterling silver b
sterling silver c

Any help will be greatly appreciated
 
A

August

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.
 
V

vezerid

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
 
Top