| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Capital Letters | Excel Discussion (Misc queries) | |||
| How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
| How do I change a column of cells to all capital letters? | Excel Worksheet Functions | |||
| Capital Letters | Excel Worksheet Functions | |||
| Auto change font to 'capital letters' | Excel Worksheet Functions | |||
Linear Mode
