Home

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
Cancel
    • 5 Answer(s)

    =find(“SHIP”;A2)

    Cancel
    Explorer Answered on 5th August 2015.
    Add Comment
    Cancel

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

    Cancel
    Explorer Answered on 20th August 2015.
    Add Comment
    Cancel

    You can find Control+F then SHIP

    Cancel
    Enthusiast Answered on 23rd August 2015.
    Add Comment
    Cancel

    Hi,

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

    =SEARCH(“SHIP”, A2)

    Cancel
    Enthusiast Answered on 30th August 2015.
    Add Comment
    Cancel

    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.

    Cancel
    Explorer Answered on 9th August 2019.
    Add Comment
    Cancel

    • Your Answer

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