If 6234 were in A1, in B1 try
=A1&"SCHERS"
Drag that down to the end of the range then Copy Paste Special Values
the new range to lose the formulas. You can then cut and paste it back to
the original location if necessary.
Note that this column will now be all text values and calculations will
probably not work,
Regards,
Alan.
"Kelli" wrote in message
...
I have a column if invoice numbers 6234,6235 etc and I need to add "SCHERS"
to each one. How do I do that w/o having to recopy the whole column