Find if nth char = specific character..

[nastech]

hi, trying to find way to see if 5th character equals the letter A.
know / tried: len( or right( but item tested may have more than 5
characters. Thanks.

[Bob Phillips]

=IF(MID(A1,5,1)="A","yes","no")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"nastech" <[email protected]> wrote in message
news:[email protected]...
> hi, trying to find way to see if 5th character equals the letter A.
> know / tried: len( or right( but item tested may have more than 5
> characters. Thanks.

[Andy Pope]

Hi,

Try the MID function.

=MID(A1,5,1)="A"

Cheers
Andy

nastech wrote:
> hi, trying to find way to see if 5th character equals the letter A.
> know / tried: len( or right( but item tested may have more than 5
> characters. Thanks.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

[Ron Coderre]

Try working with this:

If the text to test is in Cell A1:
B1:=IF(MID(A1,5,1)="A","Yes","No")

Does that point you in the right direction?

***********
Regards,
Ron


"nastech" wrote:

> hi, trying to find way to see if 5th character equals the letter A.
> know / tried: len( or right( but item tested may have more than 5
> characters. Thanks.

[nastech]

that's great, thanks..

"Bob Phillips" wrote:

> =IF(MID(A1,5,1)="A","yes","no")
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "nastech" <[email protected]> wrote in message
> news:[email protected]...
> > hi, trying to find way to see if 5th character equals the letter A.
> > know / tried: len( or right( but item tested may have more than 5
> > characters. Thanks.
>
>
>

[nastech]

that's great, thanks..

"Ron Coderre" wrote:

> Try working with this:
>
> If the text to test is in Cell A1:
> B1:=IF(MID(A1,5,1)="A","Yes","No")
>
> Does that point you in the right direction?
>
> ***********
> Regards,
> Ron
>
>
> "nastech" wrote:
>
> > hi, trying to find way to see if 5th character equals the letter A.
> > know / tried: len( or right( but item tested may have more than 5
> > characters. Thanks.

[nastech]

that's great, thanks..

"Andy Pope" wrote:

> Hi,
>
> Try the MID function.
>
> =MID(A1,5,1)="A"
>
> Cheers
> Andy
>
> nastech wrote:
> > hi, trying to find way to see if 5th character equals the letter A.
> > know / tried: len( or right( but item tested may have more than 5
> > characters. Thanks.
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>