Mar 22 2019 01:31 PM
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 return 'Uber' into a separate cell. What formula can I use for this please? Thanks for your help
Mar 22 2019 02:32 PM
= IF( ISNUMBER( SEARCH( "Uber", Sentence ) ), "Uber", "" )
If the substring is contained within the sentence SEARCH returns a number, making the IF condition TRUE.
Mar 22 2019 02:34 PM
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