=IF(MID(F23,2,1)="2","Happy","Sad")
--
If this post helps click Yes
---------------
Jacob Skaria


"Ant" wrote:

I'm trying to use a IF statement to determine if a text of 4 characters
second digit is a 2 to say "Happy" else "Sad". Ex. if "0204" then "Happy",
"Sad".

I can't get the wildcard characters to work.
--
Thank you,
Ant