Get instant live expert help on I need help with excel wildcard number

“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

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
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 S. B. in 14 mins
Hello I'm still not able to get this to work. I trying to use VBA advanced filter. I have everything filtering and working just fine except the column with "numbers" which isn't filtering. I'm thinking is based on the criteria I've set or the name manger input I gave. For the criteria, this is what I've got for the number column: =IF(K6="","*",K6) Not sure if the wildcard * works for numbers as well or just text. The idea is I have a column with only numbers and I've created a name rang to filter based on what number I select. For the name range, this is what I've got for input: =OFFSET(Lists!$O$5,,,COUNTA(Lists!$O$5:$O$110))
Solved by G. H. in 21 mins
How to enter bank account number , Ifsc code & Pan number under one cell in excel
Solved by G. D. in 12 mins
I just started using a excel spreadsheet and everytime I type in a number I get #####. In another box I can type in a number and the number will be correct. I do not know excel very well. Please Help
Solved by S. S. in 19 mins