Split UPC Question

[Guest]

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

 

[Guest]

Try this:

=MID(A1,1,LEN(A1)-1)

HTH,
Elkar

 

[Guest]

Thanks Elkar. That does the trick.

Try this:

=MID(A1,1,LEN(A1)-1)

HTH,
Elkar