Forum Discussion

jllucas2's avatar
jllucas2
Copper Contributor
Jan 13, 2021

Looking for Similar Characters in Cell

Hi all,   I need some help writing a formula.   In one cell, let's call it A1, is a 5-digit number. In another cell, let's call it B1, is a list of 5-digit numbers separated by commas.    A1 - ...
excel
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Jan 13, 2021

jllucas2 

In C1:

 

=IF(ISNUMBER(FIND(","&LEFT(A1,2),","&B1)),1,0)

  • jllucas2's avatar
    jllucas2
    Copper Contributor
    Jan 14, 2021

    HansVogelaar If the commas were replaced with carrots, (^) in cell B2, would this formula still work if I change the commas to carrots?

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Jan 14, 2021

      jllucas2 

      In general, replace both instances of "," with the delimiter in B2.

      If it is ^, use "^". If it is |, use "|", etc.

Resources