Limiting a Column to "X" Number of Characters

W

Wayne

Is there a way to limit a column to 33 characters in length? We are using
Excel 2003.

Thanks for any help.

Wayne
 
M

Marcelo

use data --> validation

Select on box allow: Text length
Data: Less than
Maximum 33

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Wayne" escreveu:
 
M

MyVeryOwnSelf

Is there a way to limit a column to 33 characters in length? We are
use data --> validation

Select on box allow: Text length
Data: Less than
Maximum 33
Click to expand...

Be aware though, that data validation works only for typed-in values.
Somebody can paste in a value that violates the limit.
 
Top