Monday, March 19, 2012

How to Restrict Data Entered in Excel to a Specific Length of Text


1. Open the spreadsheet document you'd like to apply the text restriction to.
2. Click the 'Data' tab, then click 'Data Validation.'
3. Click 'Settings.'
4. Select 'Text Length' in the 'Allow' field.
5. Select 'Less than or equal to' as the rule type.
6. Enter the maximum number of characters you'd like to allow in the text field.
7. Select 'Ignore blank' to not count spaces and other blank characters toward the text limit. If spaces should count toward the limit, leave this unchecked.
8. Type an optional message that will be displayed to the user if she attempts to enter too much information in the 'Input Message' field.
9. Select 'Show error alert after invalid data is entered' to make sure the user receives a notification that his text was not entered.
10. Click 'Save' to save your document.

Blogger news