Results 1 to 6 of 6

Find a specific sentence in a cell full of text

Threaded View

  1. #1
    Registered User
    Join Date
    04-28-2009
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    3

    Find a specific sentence in a cell full of text

    Hi,

    Very new here and very new to excel formulas.

    Could you tell me how I can find a specific sentence within a cell that contains many sentences.

    for example

    I want to find, "I am new." within a text that contains, "Hello I am Bob. I am new. I live in england."

    I am currently using =+FIND(AB$1,$V2) where AB1 contains the sentence I am looking for and V2 contains the cell full of sentences. However this returns #VALUE! when the sentence is not found. I want it to return null.

    thanks in advance.

    Ben
    Last edited by BClark86; 04-28-2009 at 01:49 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1