Trim the last digit

[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

 

[Don Guillett]

for each c in columns(3)
c.value=left(c,len(c)-1)
next

 

[immanuel]

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.