| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation formula required.
Hello Folks
I am needing a Data Validation formula so that only a single capital letter can be entered in a cell. Eg. A or B or C etc. (chars 65 to 90 inc). Please can u help. Your help is and always has been very much appreciated. Thanking you in anticipation --- Big Rick |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation formula required.
Try this:
=AND(LEN(A1)=1,CODE(A1)=65,CODE(A1)<=90) Biff "Big Rick" wrote in message ... Hello Folks I am needing a Data Validation formula so that only a single capital letter can be entered in a cell. Eg. A or B or C etc. (chars 65 to 90 inc). Please can u help. Your help is and always has been very much appreciated. Thanking you in anticipation --- Big Rick |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation formula required.
Many thanks.
When I copied the formula in DV, I got a message saying that there was an error and did I wish to continue. So I clicked yes. I was then expecting an error but was plesantly suprised when it worked just as I wanted. Thank you once again. --- Big Rick "Biff" wrote: Try this: =AND(LEN(A1)=1,CODE(A1)=65,CODE(A1)<=90) Biff "Big Rick" wrote in message ... Hello Folks I am needing a Data Validation formula so that only a single capital letter can be entered in a cell. Eg. A or B or C etc. (chars 65 to 90 inc). Please can u help. Your help is and always has been very much appreciated. Thanking you in anticipation --- Big Rick |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation formula required.
Yeah, I should have warned you about that!
Thanks for the feedback! Biff "Big Rick" wrote in message ... Many thanks. When I copied the formula in DV, I got a message saying that there was an error and did I wish to continue. So I clicked yes. I was then expecting an error but was plesantly suprised when it worked just as I wanted. Thank you once again. --- Big Rick "Biff" wrote: Try this: =AND(LEN(A1)=1,CODE(A1)=65,CODE(A1)<=90) Biff "Big Rick" wrote in message ... Hello Folks I am needing a Data Validation formula so that only a single capital letter can be entered in a cell. Eg. A or B or C etc. (chars 65 to 90 inc). Please can u help. Your help is and always has been very much appreciated. Thanking you in anticipation --- Big Rick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation - Scroll in the formula bar for a custom criteria | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Data Validation - Custom - Formula | Excel Worksheet Functions | |||
| HELP: Data > Validation ---List ----Formula | Excel Worksheet Functions | |||
| Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
Hybrid Mode
