Excel: How To: Function to identify cells with "*" [RESOLVED]
Esteemed Forum Participants and Lurkers:
===============================
Excel 2003 Functions
I regularly receive a worksheet that has some cells with "*" as the contents of the cell. I need to programmatically find the address of these cells with a function. I have tried the "Match" and "Countif" functions, but they both seem to consider the "*" as a wildcard!
=MATCH("*",A7:E7,0)
=MATCH(CHAR(CODE("*")),A7:E7,0)
=COUNTIF(A7:E7,"*")
Is there some way to turn off the wildcard action of "*"? Is there a simple function to find an occurrence of "*" as the total contents of the cell in a range of cells (row)?
Reply With Quote