Assuming your numbers are in column A and 12 digits in length, in a near-by
column put
=LEFT(A1,11)

and copy down
--
Gary''s Student


"Rowf" wrote:

I have a list of Serial Numbers that I need to remove the last digit. Anyone
know a quick and simple way of removing it.

M0808050001A -- remove the A
M0808050002C -- remove the C
M08080500039 -- remove the 9
etc

Any and all help would be greatly appreciated.