ExcelBanter - Extracting specific word in a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Extracting specific word in a cell (https://www.excelbanter.com/excel-worksheet-functions/71656-extracting-specific-word-cell.html)

Conditional Formatting

Extracting specific word in a cell

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

Extracting specific word in a cell

One way:

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

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

Conditional Formatting wrote:

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

Ron de Bruin

Extracting specific word in a cell

hi

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

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Conditional Formatting" wrote in message
...
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.

All times are GMT +1. The time now is 07:05 PM.