Results 1 to 7 of 7

Seemingly Identical Text Strings Return False When Compared

Threaded View

  1. 04-09-2016, 12:00 PM #1
    excel_fury
    excel_fury is offline
    Registered User
    Join Date
    04-09-2016
    Location
    New York, NY
    MS-Off Ver
    2007
    Posts
    4

    Seemingly Identical Text Strings Return False When Compared

    I'm having an issue very similar to this thread - except that I tried the (ingenious) code solution mentioned and find that the two text strings I am seeking to match have the exact same code but still return false using the =C2=D2 method. You'll note that in this example (matching species names) that the two names appear to match exactly, but excel is not recognizing the match. Help, please?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Identical text strings return false when compared
    By Skiingbeancounter in forum Excel General
    Replies: 13
    Last Post: 09-18-2023, 05:43 PM
  2. [SOLVED] Return true or false if cell contains multple strings of cells
    By degromek in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-25-2015, 12:00 AM
  3. Identical text strings return false when compared
    By bimalroyps2015 in forum Excel General
    Replies: 2
    Last Post: 04-13-2015, 12:18 PM
  4. [SOLVED] Mark similar but not identical text strings
    By n_ant in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-05-2014, 06:00 PM
  5. Formula to find and return text string within a cell full of text strings
    By LightingPop in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-03-2013, 11:45 PM
  6. multiple strings in each colomn cell to be compared and returned with similar strings
    By engineersoni in forum Excel General
    Replies: 3
    Last Post: 05-28-2011, 01:43 PM
  7. Seemingly identical text strings not matching
    By mr0range in forum Excel General
    Replies: 3
    Last Post: 08-27-2009, 05:28 PM

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