removing value within a string
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! :)
|