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
jllucas2's avatar
jllucas2
Copper Contributor
Jan 14, 2021

Can anyone tell me how to do this if the commas were replaced with carrots?

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jan 14, 2021

    jllucas2 

    It will be

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

Resources