Searching for specific words in a cell

[jako000]

Ive got a cell which is for example: MIN WIN GIN FIN

i need a formula that searches for a word lets say: GIN in that cell

if it finds the word the cell im in should be GIN if it doesnt the cell im in should be MIN WIN GIN FIN

is that possible?

thanks

[#2]

@jako000 

Not sure I understood correctly, but in general that's like

=IF(ISNUMBER(SEARCH("GIN",D1)),"GIN",D1)

For case sensitive use FIND instead of SEARCH.

Another point is that shall be a word (i.e. separated by spaces or punctuation and/or at the beginning/end of text) or not necessary.