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.