Forum Discussion

SJD_NY's avatar
SJD_NY
Copper Contributor
Mar 22, 2019

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 return 'Uber' into a separate cell. What formula can I use for this please? Thanks for your help

Formulas and Functions

2 Replies

Sort By
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Mar 22, 2019

    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

  • PeterBartholomew1's avatar
    PeterBartholomew1
    Silver Contributor
    Mar 22, 2019

    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.

     

Resources