Limit to 50 char only
 

Help!
Is there a way we can limit the column to 50 character
only and it will not accept data exceeding from the limit
you set.

Thanks.

Limit to 50 char only
 

Hi
try the following:
- select the cell (lets say A1)
- goto 'Data - Validation' and choose 'Custom'
- enter the formula
=LEN(A1)<=50

Note: this won't prevent copying longer data into this cell


--
Regards
Frank Kabel
Frankfurt, Germany


singkit wrote:
Help!
Is there a way we can limit the column to 50 character
only and it will not accept data exceeding from the limit
you set.

Thanks.

Limit to 50 char only
 

Or, more simply maybe....

DataValidationAllow "Text Length" less than 51

Gord Dibben Excel MVP

On Thu, 1 Apr 2004 23:57:56 +0200, "Frank Kabel"
wrote:

Hi
try the following:
- select the cell (lets say A1)
- goto 'Data - Validation' and choose 'Custom'
- enter the formula
=LEN(A1)<=50

Note: this won't prevent copying longer data into this cell