Jan 09 2020 05:27 AM
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
Jan 09 2020 05:46 AM
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.