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
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
Maybe this...
=if(left(a1,4)="Y","Yes","No")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try using COUNTIF like this
=IF(COUNTIF(A2,"*??Y*"),"Yes","No")
where A2 contains your data
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks