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