Nikki,

You can use 8456+20000 in column2, since you have fixed "2" as prefix, so
you just need to all column add "2000"

or there is another way to use =CONCATENATE(2,a1)
=CONCATENATE(2,a2)....

same thing
hope it helps

Hank

"Nikki" wrote:

Hi,

I have a spreadsheet that has one column with a 4 digit number in each line.
I would like to copy the digits in this column to a new column and then add
a 2 infront of each 4 digits.

For example.

Column 1
8456
8764
7875
7864

Column 2
28456
28764
27875
27864

I have 500 lines so would like to know if there is a quick way of doing this.

Thanks