How do you read the Nth character in a cell?

[mattlyon]

Firstly, thank you for any help you can provide.

I would like to put a logic statement into an excel formula. It would read the 5th character in a cell (say A1) and depending on what it is, put data into another cell (say B2).

Something like this

Cell a1 [12345]
Cell b2 [if character #5 is 5, display 'Yes', else display 'no']
so cell b2 shows [Yes]

 

[SkipVought]

Hi,
[tt]
=if(mid(A1,5,1)="A",true,false)
[/tt]


Skip,
[sub]
[red][/red]
[/sub]

 

[mattlyon]

Perfect Skip, Thanks!!