Hello,
Here is my situation: in a string of cells there are cells which contain only a number or only a letter. Now I want Excel to count the cells only that contain a number.
So, for example A1, A2, A3, A4 and A6 contain a number. A5 contains a letter. In cell A8, I want the solution to be 5 (for only A1, A2, A3, A4, A6 contain a number).
What is the formula for this?
Thanks,
Jazz
Bookmarks