View Single Post
  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

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

Kelli wrote:

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


--

Dave Peterson