| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| check box help | Excel Discussion (Misc queries) | |||
| ... Can I set Spell Check to automatically check my spelling ... | Setting up and Configuration of Excel | |||
| Visual basic Check Box and the IF formula | Excel Discussion (Misc queries) | |||
| Filtering by Check Boxes | Excel Discussion (Misc queries) | |||
| Excel should have a function to verify the check digit on UPC num. | Excel Discussion (Misc queries) | |||
Linear Mode
