cannot identify word in a sentence

[dschmitt]

assume the following sentence in A1:
The paper was published in Japan from a person from China.

I want to write an if loop that checks if the word "Japan" is in the sentence.
If it is then copy the sentense to B1.

How does the code look like?

[romperstomper]

At the simplest level:

Please Login or Register  to view this content.