excel: count uppercase letters in a cell
excel: how to count uppercase letters in a cell
Not the shortest formula of the bunch... just another method to accomplish
the task.
=SUMPRODUCT((CODE(MID(A1,ROW(INDIRECT("A1:A"&LEN(A 1))),1))65)*(CODE(MID(A1,ROW(INDIRECT("A1:A"&LEN( A1))),1))<91))
Rick
|