| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete a cell if it contains specific word | Excel Discussion (Misc queries) | |||
| Saving a cell name as a word doc | Excel Discussion (Misc queries) | |||
| show name when a cell has specific word | Excel Discussion (Misc queries) | |||
| Automatically Put a Value in a specific cell. | Excel Discussion (Misc queries) | |||
| how do I highlite text within a cell (specific characters) | Excel Discussion (Misc queries) | |||
Linear Mode
