+ Reply to Thread
Results 1 to 2 of 2

Checking similarity of contents in two cells

  1. 06-05-2011, 05:18 PM #1
    fredykay
    fredykay is offline
    Registered User
    Join Date
    06-05-2011
    Location
    Accra, Ghana
    MS-Off Ver
    Excel 2007
    Posts
    5

    Question Checking similarity of contents in two cells

    How do I make excel to check if a word in say, cell A1 could be found in cell B1 to give me TRUE or FALSE.
    For example
    A1 contains "Samuel Lee Jackson", B1 contains "Samuel Jackson", I want C1 to show TRUE
    A2 contains "Samuel Lee Jackson", B2 contains "Sam L Jefferson", I want C2 to show FALSE
    what do i do
    Reply With QuoteRegister To Reply
  2. 06-05-2011, 06:08 PM #2
    Haseeb Avarakkan
    Haseeb Avarakkan is offline
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Checking similarity of contents in two cells

    Hello, Try

    C1, copy down.

    =ISNUMBER(SEARCH(SUBSTITUTE(B1," ","*"),A1))
    Regards,
    Haseeb Avarakkan
    __________________________________
    "Feedback is the breakfast of champions"
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1