Wildcards in Excel Formulas

[Max997]

I am working on an Excel spreadsheet and I am tyring to write a formula
to read the 4th character of previously entered data

For instance, codes entered in column A could be eadSvf1 and eadNvf1. I
need a formula to read that 4th character and put a 1 or 2 in column B
depending on if the 4th character is an S or an N

Hope that made sense and thanks in advance.

 

[Max997]

got it, thanks anyway, I ended up using the MID function

 

[jaf]

Hi Max,
=IF(MID(A1,4,1)="S",1,IF(MID(A1,4,1)="N",2,"Neither")) and fill down.

If the text can also be lower case use...
=IF(upper(MID(A1,4,1))="S",1,IF(upper(MID(A1,4,1))="N",2,"Neither")) and
fill down.