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

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

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