ExcelBanter - Remove last 10 characters

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Remove last 10 characters (https://www.excelbanter.com/excel-discussion-misc-queries/157160-remove-last-10-characters.html)

Supe

Remove last 10 characters

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?

Roger Govier[_3_]

Remove last 10 characters

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?

Peo Sjoblom

Remove last 10 characters

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

if you have might have leading or trailing spaces

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

--
Regards,

Peo Sjoblom

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

All times are GMT +1. The time now is 12:44 PM.