| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split UPC Question
I have a column of data (column A) that contains UPC's. The length of the
UPC varies by product. I need a formula that will remove just the last digit (check digiti) of the UPC for each entry. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Split UPC Question
Try this:
=MID(A1,1,LEN(A1)-1) HTH, Elkar "MikeD1224" wrote: I have a column of data (column A) that contains UPC's. The length of the UPC varies by product. I need a formula that will remove just the last digit (check digiti) of the UPC for each entry. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Split UPC Question
Thanks Elkar. That does the trick. "Elkar" wrote: Try this: =MID(A1,1,LEN(A1)-1) HTH, Elkar "MikeD1224" wrote: I have a column of data (column A) that contains UPC's. The length of the UPC varies by product. I need a formula that will remove just the last digit (check digiti) of the UPC for each entry. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Un-Split | Excel Discussion (Misc queries) | |||
| Split box | New Users to Excel | |||
| split bar | Charts and Charting in Excel | |||
| Split a Value | Excel Discussion (Misc queries) | |||
| Advanced Window Split & Freeze Question | Excel Worksheet Functions | |||
Hybrid Mode
