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...
= IF( ISNUMBER( SEARCH( "Uber", Sentence ) ), "Uber", "" )
If the substring is contained within the sentence SEARCH returns a number, making the IF condition TRUE.