Get instant live expert help on I need help with excel wildcard in formula

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Hi, I am trying to work with VBA and writing a formula which is not working. =IF(AND(C2="STONECASTLE*", OR(V2="ON",V2="BC",V2="AB"))=TRUE,"PROSPECTUS QUALIFIED", "SUB DOC NEEDED") I am writing in Excel first and then will record macro. It keeps giving me the false value (SUB DOC NEEDED) even though both arguments of the AND formula are true. I think the problem is deriving from the * wildcard used. Please look at the highlighted column to the far right.
Solved by C. A. in 27 mins
i need a wildcard for numbers on the left side of the decimal when dealing with rounding up and down with specific criteria but focusing on the right side of the decimal only.
Solved by A. B. in 11 mins
I have a formula that isn't quite working. Need to look in column "B" for RIGHT, LEFT, RT, LT, R, L & return a "R" or "L" in a new column. If not present, then the cell = blank. An example would be: SQUAMOUS CELL CARCINOMA SKIN/ L EAR AND EXTRN AURIC CANAL It should return a value of "L". Left cannot be a wildcard because the word "CLEFT" can also be in column B. Here is the formula i am using - but it is returning all "R"s regardless. =IF(COUNTIFS(B1609,"Right")>0,"R",IF(COUNTIFS(B1609,"*RT*")>0,"R",IF(COUNTIFS(B1609,"Left")>0,"L",IF(COUNTIFS(B1609,"LT")>0,"L",IF(COUNTIFS(B1609,"*R *")>0,"R",IF(COUNTIFS(B1609,"*L *")>0,"L "," "))))))
Solved by C. J. in 27 mins
Hi. Is there any excel formula to calculate mileage in excel
Solved by A. Y. in 28 mins
Hi there, I need excel quick help in fixing excel formula.
Solved by G. Q. in 13 mins