MID Formula

[carl]

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.

carl wrote:
>
> 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

[Gary L Brown]

=mid("BOX00A8Y0L39 ",10,2)
HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"carl" wrote:

> 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.

[Marcelo]

mid(a2,10,2)

hth
regards from Brazil
Marcelo

"carl" escreveu:

> 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]

Carl

Assuming your string is in A1

=mid(A1,10,2)

Dave

"carl" <carl@discussions.microsoft.com> wrote in message
news:41493691-69D8-4D15-A5C8-15BF2E0EE6AF@microsoft.com...
>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]

Oopsie.

change the 11 to 10

Dave Peterson wrote:
>
> =mid(a1,11,2)
> maybe???
>
> or
> =--mid(a1,11,2)
>
> if you want that 39 to be treated as a number--not text.
>
> carl wrote:
> >
> > 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

--

Dave Peterson