If you use a Helper Column, you can do the Formula below. Then Copy the
Results and use Edit Paste Special to get the Values. then delete the
original data, if necessary.

=IF(LEN(A1)=4,LEFT(A1,2),LEFT(A1,1))

If you are doing this with numbers, you may want to use a slight variation:
=VALUE(IF(LEN(A1)=4,LEFT(A1,2),LEFT(A1,1)))

tj

"Patrick" wrote:

I have a column with numbers that are either 3 or 4 characters in length. I
would Like to delete just the last two characters. Is there an easy way to do
this?
Thanks