| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove first few characters | Excel Worksheet Functions | |||
| Remove top bit characters | Excel Discussion (Misc queries) | |||
| Need to remove selected characters | Excel Discussion (Misc queries) | |||
| I need to remove characters ... | Excel Discussion (Misc queries) | |||
| remove last three characters of cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
