How do I add text to a column of numbers

K

Kelli

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
 
A

Alan

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

Dave Peterson

Insert a new column B and use a formula like:
=a1&"SCHERS"
and drag down.

Then edit|copy those cells and select the original range and
edit|paste special|values
(and delete the helper column.)
 
Top