Hello

I have columns of data that are maded up of markers. Such as XYXNXXNXNXNX.

I'd like a formula that looks at the 3rd character onwards and if a 'Y' appears then It returns the word "yes" else "no"

Can anyone help?

Thanks