Extracting specific word in a cell

[Guest]

Column A Column B
Western Europe Europe
Latin America
Western Europe Europe
North America

I'd like to create a formula in column B that would display all Europe only.
Thanks.

 

[Dave Peterson]

One way:

=if(countif(a1,"*europe*")=0,"","Europe")

Another:
=if(iserror(search("europe",a1)),"","Europe")

 

[Ron de Bruin]

hi


Maybe this will help you
=IF(COUNTIF(A1,"*Europe*")>0,"Europa","")