Max Character Limit

[zbrlvr]

Version: v.X
Operating System: Mac OS X 10.3 (Panther)

I'm trying to set a character limit on cells in a table, but am unable to find the option. Is there one?

 

[JE McGimpsey]

Version: v.X
Operating System: Mac OS X 10.3 (Panther)

I'm trying to set a character limit on cells in a table, but am unable to
find the option. Is there one?

As an alternative to Bob's excellent suggestion, here are two more:

1) You CAN set a limit on cell entries using Data/Validation (select
Text Length from the Allow dropdown). But as Bob suggested, this won't
prevent the user from entering too many characters only to get an error
message (thankfully, the entry is retained in the formula bar, so one
can edit the too-long entry, rather than having to retype the whole
thing).

2) Depending on the number of table entries, etc., I've built sheet with
cells that users double-clicked into which then brought up a Userform.
One has character-by-character control of userform entries, so you could
even give a count-down as characters are entered, and prevent any more
characters being entered.

 

[zbrlvr]

Thanks to both of you! I've tried both of your suggestions and they both work, although because I'm editing a worksheet created by someone else J.E.'s solution was the one I needed! Although you have answered my question in Excel, I'm curious if there's a solution similar for a table in Word. Would either of you know?

 

[JE McGimpsey]

I'm curious if there's a solution similar for a table in Word. Would either
of you know?

If you insert a, you can use a Text Form Field (from the Forms toolbar)
to limit the number of characters.

 

[zbrlvr]

For some reason that's not working. It's letting me set the max length but it's not actually keeping me from entering more characters.

 

[JE McGimpsey]

For some reason that's not working. It's letting me set the max length but
it's not actually keeping me from entering more characters.

When you reply to your own original message, it's impossible to tell
what "that" isn't working...

Try replying to the message with the reply that you're referring to.