View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jane Jane is offline
external usenet poster
 
Posts: 202
Default removing value within a string

I believe these problems have the same solution.

1st problem:
I would like to be able to remove the zero that is placed 3 digits from the
RIGHT. The values a
66014
8004
8015

The values should look like:
6614
804
815

2nd problem in the same mproject:
I would like to be able to remove the values, text, and/ or spaces that are
16 places from the RIGHT.
The entry is:
TRAD EC JEANS (S) | CL11941033

The entry should look like:
TRAD EC JEANS

thank you for your help! :)