FORMULA TO MINUS TEXT CHARACTERS
 

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

FORMULA TO MINUS TEXT CHARACTERS
 

=RIGHT(A1,LEN(A1)-3)
--
Gary''s Student - gsnu2007c

FORMULA TO MINUS TEXT CHARACTERS
 

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" wrote in message
...
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

FORMULA TO MINUS TEXT CHARACTERS
 

On 4 Feb, 16:07, "Bernie Deitrick" <deitbe @ consumer dot org wrote:
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" wrote in message

...



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- Hide quoted text -

- Show quoted text -

Thanks bernie