Hi

Try
=LEFT(A1,LEN(A1)-10)

--
Regards
Roger Govier



"Supe" wrote in message
...
I pull a report that lists the item description and the 10 digit UPC all in
the same cell with the UPC listed at the end. Is there a formula that
could
cut off the last 10 characters in each cell?