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
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
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" <[email protected]> wrote in message
news:[email protected]...
>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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks