Assume that you want the number of cells containing only text in the range of A1:A10. Type the formula below and press Enter: =COUNTIF(A1:A10,"*")