Text Restrictions

[Guest]

Using Excel 2000 and without having to get into Macros, is there a way to set
a validation such that only an uppercase character can be enterted into the
cell? For example, the cell would allow an uppercase "X" but nothing else?

Thank you for all help / suggestions,

 

[Jim Cone]

=EXACT(C11,UPPER(C11))
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"LPS" <[email protected]>
wrote in message
Using Excel 2000 and without having to get into Macros, is there a way to set
a validation such that only an uppercase character can be enterted into the
cell? For example, the cell would allow an uppercase "X" but nothing else?
Thank you for all help / suggestions,

 

[Guest]

Try this:

Select cell A1

From the Excel main menu:
<data><validation><settings tab>
Allow: custom
Formula: =EXACT(A1,"X")
(Adjust the Error Alert so it mentions that only uppercase "X" is allowed)
Click the [OK] button

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Guest]

Thank you Ron. That does, indeed help.

Cheers,
--
LPS

Try this:

Select cell A1

From the Excel main menu:
<data><validation><settings tab>
Allow: custom
Formula: =EXACT(A1,"X")
(Adjust the Error Alert so it mentions that only uppercase "X" is allowed)
Click the [OK] button

Does that help?
***********
Regards,
Ron

XL2002, WinXP

Using Excel 2000 and without having to get into Macros, is there a way to set
a validation such that only an uppercase character can be enterted into the
cell? For example, the cell would allow an uppercase "X" but nothing else?

Thank you for all help / suggestions,