Can I limit a cell to 72 characters? How?
 

Can you limit a cell to a certain amount of characters? If so how?

For typing in text you can use datavalidationallow text lenght, that will
pop up an error message but it won't stop pasting. If you want to
automatically truncate anything more than 72 you would need VBA

Regards,

Peo Sjoblom

"Chris" wrote:

Can you limit a cell to a certain amount of characters? If so how?

DataValidation Allow Text length equal to or less than 72

"Chris" wrote in message
...
Can you limit a cell to a certain amount of characters? If so how?