Trim the last digit

  • Thread starter Thread starter Ber
  • Start date Start date
B

Ber

I am using 12 digits upc codes in all the cells of one column but I nee
only 11 digits. How can I trim the last digit in all the cells for tha
column?

Thanks
 
If your UPCs are stored as numbers, and your first datum is in A1, you could
create another column with the following formula:

=INT(A1/10)

If your data is textual, use:

=LEFT(A1,11)

And drag down to the end of the data range.

/i.
 
Back
Top