Formula Help

[SJD_NY]

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

[#2]

@SJD_NY 

= IF( ISNUMBER( SEARCH( "Uber", Sentence ) ), "Uber", "" )

If the substring is contained within the sentence SEARCH returns a number, making the IF condition TRUE.

[#3]

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