Limit Text

[timmyc123]

Hello,

I have a column of cells that I would like to limit to 15 characters of text each. I used data validation but it will only pop-up a message saying that it is over 15 characters. Is there a way to have it automaticall cutoff or have it not let you type anymore once 15 characters are used up?

Thanks in advance!

Tim

[Carim]

Hi Tim,

In Data Validation, in the Allow Section
select : Text Length
in data : Equal to
in length : 15 ...

[timmyc123]

Thanks for the fast response, but it still only shows the error...it does not clip it or not let you type anymore...

[Carim]

Ok then ...
Forget about Data Validation ...
Let users input as many characters as they want, and have
=Left(A1,15) to truncate their text ...

[timmyc123]

ok, how do I apply that to an entire column...

[Carim]

Hi,

Just copy formula all the way down ...