Thread
:
Removing a check digit
View Single Post
#
3
Posted to microsoft.public.excel.misc
Ardus Petus
Posts: n/a
Removing a check digit
=LEFT(A1,LEN(A1)-1)
HTH
--
AP
"cwd58" a écrit dans le message de news:
...
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?
Reply With Quote