Using Data Validation to limit entry of number of characters in a cell.

Hi

When you want to use Data Validation to limit the entry of the number of characters to a cell does this apply only to the cell that you are entering the characters or can it also apply to a cell that contains a LEN(A1) formula, for instance? Also,does the Data Validation limitation function includes spaces as well? Will the message appear while you are entering the characters (when it has reached the limit) or will it wait until you have hit Enter?

Thanks

Originally Posted by Patish

Hi

When you want to use Data Validation to limit the entry of the number of characters to a cell does this apply only to the cell that you are entering the characters or can it also apply to a cell that contains a LEN(A1) formula, for instance?

Not sure I understand, but each cell needs to have a validation rule.

Originally Posted by Patish

Also,does the Data Validation limitation function includes spaces as well?

Yes

Originally Posted by Patish

Will the message appear while you are entering the characters (when it has reached the limit) or will it wait until you have hit Enter?

It will wait until enter has been hit.