a way to limit the characters allowed in a cell?

E

EmRit24

is there currently a way in excel to limit the amount of characters
that can be typed into a cell?
if not, is there a word count function?
thanks.
 
P

patrick

Try Data>Validation
You can limit the characters by choosing "Text Length"
Functions include COUNT, COUNTIF, COUNTA See the help for each function. One
of these should work for you.
Pat
 
P

Per Erik Midtrød

is there currently a way in excel to limit the amount of characters
that can be typed into a cell?
Click to expand...

Take a look at Data - Validation.
Choose text length.

Per Erik
 
Top