View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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