finnstone
asked on
formula to count the number of capital letters in an excel formula
i need a formula to count the number of capital letters in an excel formula
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Or:
=INDEX(FREQUENCY(CODE(MID(A1,COLUMN($1:$65536),1)&"~"),{64,91}),2)
Open in new window
or:Open in new window