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
|