You mean column B should show the first 2 words of Column A ?

Or you have some other way of relating the 2 columns ?

NickHK

"massi" wrote in message
...
Hi,
i have a table with some values in a column as follow:
column A | column B
---------------------------
text 1 |
text 2 |
text 3 |

i would like a formula that recognise some key words in column A and
return
in column B a value

so for example if text 1 has the word fire detection room A i should have
in
column B a text that says fire detector,
if text 1 says gas detector room 2 i would like to have in column B gas
detection and so on.
is there anyone that can help with this please?
thanks in advance