Capital Letters Only
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 |
Capital Letters Only
Use a custom validation (under "allow") and input this formula (under
"formula"). =ISERROR(FIND(UPPER(A1),A1))=FALSE "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 |
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 |
All times are GMT +1. The time now is 11:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com