Does a wildcard (* or ?) work in an if statement? For example in A1 I have the word "nextlevel" (wo the ""). In A2 I have: If(A1="nex*","Ok","No"). I have even tried If(A1="=nex*","ok","no"). In both instances I get "no", when I should be getting "ok". I figured out a work around using the left function - but still think the if statement should have worked.
A related question, when would I use "nex*" versus "=nex*"?
Thank you. Marie
A related question, when would I use "nex*" versus "=nex*"?
Thank you. Marie