Thanks to all that replied.

Jim got it first though.

Thanks Jim!


"Jim Thomlinson" wrote:

PasteSpecial - Values... when you past back to column A. Otherwise you are
pasting a formula that is referencing the column to the left of A which does
not exist...
--
HTH...

Jim Thomlinson


"Hernan" wrote:

I have a column (A) of 300+ rows, with 10 digits in each cell. I need to
remove the last digit of each cell.

I tried =LEFT(A2,9) on column B and then copied the fomula to the last row,
but when I deleted column A, coumn B gave me a #REF! error. Is there a way to
convert those number in column B?

Or another way to do this without the use of =LEFT function?

TIA

Hernan.