Adding to a column of numbers
 

Is it possible to add a number to an existing column of random numbers? For
example say the column has the following product ID numbers... 5402 12887
3450 44622 etc... Is it possible to select from the column and add 40- so
that the ID numbers would now read 40-5402 40-12887 40-3450 40-44622 etc
in order to catagorize product groups without changing each individual cell?

Adding to a column of numbers
 

Hi Colleen

I would do it using a "helper" column, which can then be deleted

- in a column adjacent to your numbers (assume numbers start in A1) type
="40-"&A1

- now fill down as far as necessary. The helper column should now display
the numbers like you want

- select the numbers in the helper column and copy them

- click on A1 and choose Edit / Paste Special
- choose VALUES
- click OK.

your original numbers should now be prefixed with 40-
the helper column can now be deleted
(always try new things on a copy of the workbook first!).


Cheers
JulieD

julied at hctsReMoVeThIs dot net dot au


"Colleen" wrote:

Is it possible to add a number to an existing column of random numbers? For
example say the column has the following product ID numbers... 5402 12887
3450 44622 etc... Is it possible to select from the column and add 40- so
that the ID numbers would now read 40-5402 40-12887 40-3450 40-44622 etc
in order to catagorize product groups without changing each individual cell?