Counting characters
Thanks, just what I needed.
--
Howard
"JLatham" wrote:
Easy way to do it is to use Data -- Validation and choose 'Text Length' as
the type of validation to use. Then you can set min/max/exact length to
allow for the cell.
Another way would be to use another cell to check the length. Say you want
to check A1 for length:
=IF(LEN(A1)<20,"Not 20 characters","Is 20 Characters")
"Howard" wrote:
Is there any way to count characters (spaces included) in a cell to insure
that the characters in a specific cell do not exceed a preset number?
Thanks everyone
--
Howard
|