Hi Patrick

so if you have
123
1234
you want
1 and
12
if so then in a column next to your data enter
=LEFT(A1,LEN(A1)-2)
(where A1 is the first value of the orginal data)
and fill down - move cursor over bottom right of cell until you see a + then
double click
if you want to get rid of the original numbers, select this new column &
copy it,
click on the first cell of the old numbers and choose edit / paste special -
values

Hope this helps
Cheers
JulieD

"Patrick" wrote in message
...
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