View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MikeD1224 MikeD1224 is offline
external usenet poster
 
Posts: 34
Default 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