That works great if the number is at the beginning of the string, is there a
way to do it if the number is anyplace in the string ?

"JLatham" wrote:

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.