Removing a check digit

C

cwd58

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

Bob Phillips

=left(a1,13)


--
HTH

Bob Phillips

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

David Biddulph

cwd58 said:
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?
Click to expand...

=LEFT(A1,LEN(A1)-1)
 
Top