You can do this with data validation

Select the cell(s) in question
Goto the menu DataValidation
AllowText length
Fill in the info
OK

--
Biff
Microsoft Excel MVP


"willemeulen" wrote in message
...

How do I program a cell to have let say a maximum word/sentence length
of 50 spaces.:Bgr


--
willemeulen

Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands)
------------------------------------------------------------------------
willemeulen's Profile:
http://www.thecodecage.com/forumz/member.php?userid=285
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=100198