How do I count the number of cells that contain the string "A*" - without treating the star as a wildcard character?
+4
A:
Quoted directly from Excel help documents: "If you want to find an actual question mark or asterisk, type a tilde (~) before the character."
COUNTIF(A1:A4,"A~*")
Will Bickford
2009-08-26 21:47:05
Great - thanks very much.
tequila2k
2009-08-27 08:49:37