Forum Discussion
Formula Help
Hi there, I'm rusty on my Excel and would like help with a formula please... I want to search a cell which has a sentence of text to see if it contains 'Uber' anywhere in sentence, and if so to retur...
Hi SJD_NY,
Supposing that the sentence is in cell A1, please try this formula below:
=IF(ISNUMBER(SEARCH("Uber",A1)),"Uber","")
If the sentence contains "Uber", the formula will return "Uber, otherwise, it will return nothing!
Hope that helps