Indicator (Yes or No) when the row has a string of texts and numbers

I'm trying to find a function that allows me determine if the number is present in a given rows of texts and number.

I'm having a problem with this one because the row has semi-colon. Please see attached.

The function should be able to determine if the number is present in the rows or not. If it is, the function will result to YES. If not, then a No.

Please see attached file. Thank you.