Limiting text length with basic controls


show more Limiting text length with basic controls provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010: Data Validation in Depth show less
please wait ...

Limiting text length with basic controls

With data validation, you can control the length of entries in a range of cells. For example, in column A, if we want to put in Social Security Numbers, these are always nine characters in length, and we don't want any entries that consist of eight or 10 characters, or anything else that's not nine. Employee IDs in your organization might be always six characters in length. You want to make sure that that's true by putting in a validation rule here, too, that controls the length of the entry. Phone numbers these days are nearly always 10 characters.

You could put restrictions here, too, by way of data validation. And although this feature is called Text length, we could even use it for certain kinds of numerical information, although usually there's a better way by using other criteria, for example, to control prices. Let's focus on column A here. We want to make sure that the Social Security Number entries here are always nine characters. You should also accompany this...

Limiting text length with basic controls
Video duration: 3m 51s 59m 45s Intermediate

Viewers:

Limiting text length with basic controls provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010: Data Validation in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...