Capital Letters Only
Another version:
=EXACT(A1,UPPER(A1))
But this does allow:
SIMON #3-1234 JEFFORD
(non-alpha's are ok)
Simon Jefford wrote:
Is it possible to ensure that only capital letters are entered into a cell.
I have tried using a list within data-validation but the cell still allows
both upper and lower case entries.
Any ideas would be much appreciated.
Thanks
Simon
--
Dave Peterson
|