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.
|