Monthly archives for February, 2005

Count number of asterisk (*)

Feb10
2005 Leave a Comment

Written by admin

To count number of asterisk (*) in a column use this formula:
=COUNTIF(A1:A3, "=~*")

Posted in String Operations - Tagged count, excel functions, wildcard