M
Matthew Dyer
currently I am using the following code to determine if my reference
cell starts with S
=if(LEFT(B2, 1)<>"S", "true", "false")
I want to use a wildcard instead to avoid having to use the nested
function but the following formula doesnt work
=IF(B2="S*","true", "false")
i understand that the first fomula is looking for S as the left-most
charachter in cell B2. I also understand that the second formula is
looking for S* as the value of B2. How can I achieve my goal of
looking for any value that BEGINS with S without using a nested
function?
cell starts with S
=if(LEFT(B2, 1)<>"S", "true", "false")
I want to use a wildcard instead to avoid having to use the nested
function but the following formula doesnt work
=IF(B2="S*","true", "false")
i understand that the first fomula is looking for S as the left-most
charachter in cell B2. I also understand that the second formula is
looking for S* as the value of B2. How can I achieve my goal of
looking for any value that BEGINS with S without using a nested
function?