Can you limit a cell to a certain amount of characters? If so how?
P Peo Sjoblom Dec 28, 2004 #2 For typing in text you can use data>validation>allow 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
For typing in text you can use data>validation>allow 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
