Let's say: a in A1, b in A2, c in A3
Your formula in B1 ="sterling siver "&A1
copy from B1 down to B3


"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