ExcelBanter - Removing a check digit

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Removing a check digit (https://www.excelbanter.com/excel-discussion-misc-queries/95490-removing-check-digit.html)

cwd58

Removing a check digit

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?

Bob Phillips

Removing a check digit

=left(a1,13)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"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?

Ardus Petus

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?

David Biddulph

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

All times are GMT +1. The time now is 02:45 PM.