Text Restrictions

L

LPS

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,
 
J

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,
 
R

Ron Coderre

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
 
L

LPS

Thank you Ron. That does, indeed help.

Cheers,
--
LPS


Ron Coderre said:
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


LPS said:
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,
Click to expand...
Click to expand...
 
Top