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?
|