I have a column (approx. 500 rows) with data consisting of numbers, letters and a few cells have numbers followed by alphabets. I want to count the number of cells that contain numbers followed by alphabets.
Sample data
23
23a
23b
34
34a
ABC
67
75
75a
DEF
The answer is 4 (four cells containing data 23a, 23b, 34a,75a)
Thanks for the help.
Satish
Bookmarks