[Pat88]

I have an excel data sheet and like to use MERGEFIELD and IF to check if a part of the value is in the excel field.

For example i have the field "participants" with the following values:

Thomas;Philip;Patrick

I like to check with the following command if the Name "Patrick" is in this field:

{ IF { MERGEFIELD participants } = "Patrick" "yes" "no" }

Word shows me the result "no". How can I change my command that it doesn't matter if before or after the name any value is? I tried it with * but it doesn't work.

Thanks for your ideas