Extracting specific word in a cell

  • Thread starter Conditional Formatting
  • Start date
C

Conditional Formatting

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.
 
D

Dave Peterson

One way:

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

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