One way:
If you want to count actual numbers, too, use COUNTA():
=COUNTA(A1:A210)
If you want to exclude actual numbers (but not text numbers):
=COUNTA(A1:A210)-COUNT(A1:A210)
In article ,
"Debi" wrote:
In Excell how would I count cells that contain both text and numbers that are
formated as text?
Example in A1 through A210 there are entries such as ME90.05, M80304, BE80.04
|