View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default Count Cells with alphanumeric data

If all of the ones with number have a number as the 1st character, then a
formula like this should work, just change the A1:A8 range to whatever range
you need:
=COUNTIF(A1:A8,"<A")


"Aris" wrote:

Hi,

I'm just trying to count the cells in a range that have alphanumeric data.

example: asd, we, rty, 22r, 45aa, 1s, wer, tyu.

I need to count all cells in that range that have numbers.