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