software

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.One way:

=if(countif(a1,quot;*europe*quot;)=0,quot;quot;,quot;Europequot;)

Another:
=if(iserror(search(quot;europequot;,a1)),quot;quot;,quot;Europequot;)

Conditional Formatting wrote:
gt;
gt; Column A Column B
gt; Western Europe Europe
gt; Latin America
gt; Western Europe Europe
gt; North America
gt;
gt; I'd like to create a formula in column B that would display all Europe only.
gt; Thanks.

--

Dave Peterson

hiMaybe this will help you
=IF(COUNTIF(A1,quot;*Europe*quot;)gt;0,quot;Europaquot;,quot;quot;)

--
Regards Ron de Bruin
www.rondebruin.nlquot;Conditional Formattingquot; gt; wrote in message
...
gt; Column A Column B
gt; Western Europe Europe
gt; Latin America
gt; Western Europe Europe
gt; North America
gt;
gt; I'd like to create a formula in column B that would display all Europe only.
gt; Thanks.
gt;