Suppose, you have been given a string in A1 = "234, Washington D. C. @ 45609"
The challenge before you is to write 2 formulas to count the number of
1. Alphabets
2. Numerals
3. Other Characters other than space
For example, in above string, number of alphabets = 12 and number of numerals = 8 and Number of other Characters other than Space = 4.
Once again, all 3 need to be counted separately. Hence, you have to make 3 formulas – One for alphabets and one for numerals and one for other Characters other than Space.
We should be able to use the formula in Excel 2003 also, hence multiple SUBSTITUTES will not be working here.
You may choose to pose your answer in comments section.
Note – Solution to this challenge will be published after 1 month i.e. on 09-Nov-15.