Biff,
can you tell me what the " does in the solution?

your solutions worked perfectly! thank you!
very much appreciated :)

jane

"T. Valko" wrote:

Try these:

1st problem:

=SUBSTITUTE(A1,RIGHT(A1,3),RIGHT(A1,2))+0

2nd problem:

=LEFT(A1,FIND("(",A1)-2)

Biff

"Jane" wrote in message
...
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! :)