MID Formula

[Guest]

I am trying to find a formula that will look at this 12 character string:

BOX00A8Y0L39

And return the 10th and 11th characters.

Thank you in advance.

 

[Dave Peterson]

=mid(a1,11,2)
maybe???

or
=--mid(a1,11,2)

if you want that 39 to be treated as a number--not text.

 

[Guest]

=mid("BOX00A8Y0L39 ",10,2)
HTH,

 

[Guest]

mid(a2,10,2)

hth
regards from Brazil
Marcelo

"carl" escreveu:

 

[Dave]

Carl

Assuming your string is in A1

=mid(A1,10,2)

Dave

 

[Dave Peterson]

Oopsie.

change the 11 to 10

=mid(a1,11,2)
maybe???

or
=--mid(a1,11,2)

if you want that 39 to be treated as a number--not text.