software

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

Use a custom validation (under quot;allowquot;) and input this formula (under
quot;formulaquot;).

=ISERROR(FIND(UPPER(A1),A1))=FALSE

quot;Simon Jeffordquot; wrote:

gt; Is it possible to ensure that only capital letters are entered into a cell.
gt;
gt; I have tried using a list within data-validation but the cell still allows
gt; both upper and lower case entries.
gt;
gt; Any ideas would be much appreciated.
gt; Thanks
gt; Simon

Another version:

=EXACT(A1,UPPER(A1))

But this does allow:
SIMON #3-1234 JEFFORD
(non-alpha's are ok)

Simon Jefford wrote:
gt;
gt; Is it possible to ensure that only capital letters are entered into a cell.
gt;
gt; I have tried using a list within data-validation but the cell still allows
gt; both upper and lower case entries.
gt;
gt; Any ideas would be much appreciated.
gt; Thanks
gt; Simon

--

Dave Peterson