On Wed, 2 Nov 2005 12:37:28 -0800, Pam
wrote:

I have set the validation on a cell not to exceed 25 characters.
When you type more then that a message comes up telling you
you have to many. When you hit cancel it deletes all of what you
have put in. I am trying to find a way so that it just leaves the first
25 characters and cuts the rest off. Any idea how to do this?
Thanks

I can't think of an immediate way to achieve this in the same cell,
but you could use a helper cell which contains

=left(yourdatacell,25)

then remove the validation altogether from yourdatacell.

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________