Remove last 10 characters

G

Guest

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?
 
P

Peo Sjoblom

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

if you have might have leading or trailing spaces

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I stop Excel from dropping leading zeros? 9
Split UPC Question 2
formatting a lookup 4
Separating Data in one cell to multiple cells 1
Comparing two lists 3
Excel should have a function to verify the check digit on UPC num. 1
Excel Populate workbook A from Data in workbook B based off criteria in Workbook C 0
Simple macro 1

Top