Thread
:
Removing a check digit
View Single Post
#
4
Posted to microsoft.public.excel.misc
David Biddulph
Posts: n/a
Removing a check digit
"cwd58" wrote in message
...
I want to remove the check-digit from a list of barcode numbers. So
33609005000160 will be changed to 3360900500016.
Can this be done in Excel or Access?
=LEFT(A1,LEN(A1)-1)
--
David Biddulph
Reply With Quote