98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Low Priority · Version 2003
Natalie has attended:
Excel Advanced course
Access Intermediate course
Excel
Is it possible to set up data validation so that whatever case someone types information into a cell it automatically formats it to uppercase?
RE: Excel
You can use Excel's Data Validation tool to prevent the user from entering anything except text in the desired case. Select the range of cells to which you want to apply Validation, choose Validation from the Data menu and choose Custom from the Allow list. In the formula box, enter any one of the following formulas, depending on what case you want to allow. Change the reference from A1 to the address of the first cell in the selected range.
=EXACT(A1,UPPER(A1))
=EXACT(A1,LOWER(A1))
=EXACT(A1,PROPER(A1))
With this validation in place, the user can enter only upper, lower, or proper case.
Wed 10 Dec 2008: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Selecting blank cells within a range of dataSelect the range of data which includes the blank cells that you would like to select. Press the F5 key, this will take you to the GoTo dialogue box where you can click on Special and then select Blanks. |