Home |
Search |
Today's Posts |
#1
|
|||
|
|||
a way to limit the characters allowed in a cell?
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. |
#2
|
|||
|
|||
Try DataValidation
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 "EmRit24" wrote: 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. |
#3
|
|||
|
|||
Cheeck the help description on validation
"EmRit24" wrote: 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. |
#4
|
|||
|
|||
On 29 Apr 2005 12:51:29 -0700, "EmRit24" wrote:
is there currently a way in excel to limit the amount of characters that can be typed into a cell? Take a look at Data - Validation. Choose text length. Per Erik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exported File truncating cell data after 255 characters | Excel Discussion (Misc queries) | |||
limit number of characters in a cell | Excel Discussion (Misc queries) | |||
Visible cell characters | Excel Discussion (Misc queries) | |||
Format spreadsheet so no input allowed if certain cell is =<0 | Excel Worksheet Functions | |||
#### error if cell has more than 255 characters | Excel Discussion (Misc queries) |