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