View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cin Cin is offline
external usenet poster
 
Posts: 19
Default Adding something to a column

This formula should do it:

="sterling silver " & A1

Where A1 is the first cell with data...

"August" wrote:

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