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

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

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

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