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
  • 5 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

    We all interested in having the knowledge on different questions and finding words. The research paper writing service writers placed best excel questions and resources. So, everyone will get the interesting reports and essay words for the question writers.

    Explorer Answered on 9th August 2019.
    Add Comment
  • Your Answer

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