and sorry I didn't combine my questions but for the 2nd solution also.... if
'from the right is need, why go with LEFT? and how does the -2 work into it?
I just want to be able to understand it so I can explain it to some one else
if asked and alter if needed for future use.

Thank you again! 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! :)