How to find a word from within cells in Excel?

How to find  SHIP ??   says in Cell A2?

AD0000ADMN-SHIPMO000

Explorer Asked on 14th July 2015 in Excel for Windows.
Add Comment
  • 4 Answer(s)

    =find(“SHIP”;A2)

    Explorer Answered on 5th August 2015.
    Add Comment

    =search(“ship”, a2).
    This formula will help in creating conditions based on cell content for instance.

    Explorer Answered on 20th August 2015.
    Add Comment

    You can find Control+F then SHIP

    Enthusiast Answered on 23rd August 2015.
    Add Comment

    Hi,

    The most ideal option would be availing a function . find the syntax below:

    =SEARCH(“SHIP”, A2)

    Enthusiast Answered on 30th August 2015.
    Add Comment
  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of use.