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?