looking for NOTRIGHT() equivalent

  • Thread starter Thread starter Eliezer
  • Start date Start date
E

Eliezer

Hello... I have a bunch of strings of differing length,
and I want to remove the leftmost eight characters from
the string. I know that RIGHT() and LEFT() can choose
which ones, but how do I "crop" characters; i.e. - remove
a specific length of characters?

in case I'm not being clear, which I think I'm not, one
example is:

15424879555555
521457555555
4797521386555555

I want to get rid of the six trailing 5's. Thanks!
 
Your question seems slightly unclear as to whether you want to get rid of the 8
characters to the left, or the 5s to the right, so just in case:-

=LEFT(A1,LEN(A1)-6) to get rid of 6 to the right, or

=RIGHT(A1,LEN(A1)-8) to get rid of 8 to the left.
 
Back
Top