Wildcards in Excel Formulas

  • Thread starter Thread starter Max997
  • Start date Start date
M

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