a way to limit the characters allowed in a cell?

  • Thread starter Thread starter EmRit24
  • Start date Start date
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.
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
vlookup character limitations 1
Adding the total # of characters in multiple cells 3
How to limit the characters in a cell 1
Maximum characters in cell 2
Limit to 5 characters... 2
Code character limit with Resize or Transpose or cell? 8
text exceeds allowed number of characters per cell 1

Back
Top