Just to add on with another problem also to deal with occurance..

I have this code B744DFCC on Cell A1..

My excel has a criteria which i need to search for "7". So if i find F in my code, i display "Y" else i display X. How do i do it?

Thanks..