» Restricting the Number of Characters Entered into a Cell
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Restricting the length of entries in column A to a maximum of 5 characters.
Solution:
Use Data Validation:
1. Select Column A.
2. Data --> Data Validation --> Settings --> Custom
3. Enter the following formula in the Formula box:
=LEN(A2)<6
4. Click OK.
If an entry is longer than 5 characters, an error message will pop up, forcing the user to try again.
Book Store:
Recommended Books:
- The Ernst & Young Business Plan Guide
- Investing for Dummies, Third Edition
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Microsoft Outlook 2002 for Dummies
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
No comments have been submitted.
