FORMULA TO MINUS TEXT CHARACTERS

[K]

Hi, i have data on my spreadsheet please see below
ME54001528
ME54001961
ME54002025
ME54002160
ME54001207
ME5EE120
ME5EE200
ME54000441
ME51831103
ME54002119
ME51842129
ME54001784
ME54001212
ME51842123
ME54001952
ME54002086
ME54001350
i want formula which should minus first three text characters or you
can say take away first three text digits and put rest of the text in
cell. I know the formulas of =LEFT and =RIGHT but i dont know how to
minus first three or last three text characters whith these formulas.
Is there anybody can help me

 

[Gary''s Student]

=RIGHT(A1,LEN(A1)-3)

 

[Bernie Deitrick]

K,

Lots of ways to do this:

Take away the first 3 characters.
=MID(A1,4,LEN(A1))
=RIGHT(A1,LEN(A1)-3)


Take away the last three characters.
=MID(A1,1,LEN(A1)-1)
=LEFT(A1,LEN(A1)-3)


Take away first and last 3
=MID(A1,4,LEN(A1)-6)
=RIGHT(LEFT(A1,LEN(A1)-3),LEN(LEFT(A1,LEN(A1)-3))-3)

HTH,
Bernie
MS Excel MVP

 

[K]

K,

Lots of ways to do this:

Take away the first 3 characters.
=MID(A1,4,LEN(A1))
=RIGHT(A1,LEN(A1)-3)

Take away the last three characters.
=MID(A1,1,LEN(A1)-1)
=LEFT(A1,LEN(A1)-3)

Take away first and last 3
=MID(A1,4,LEN(A1)-6)
=RIGHT(LEFT(A1,LEN(A1)-3),LEN(LEFT(A1,LEN(A1)-3))-3)

HTH,
Bernie
MS Excel MVP






- Show quoted text -

Thanks bernie