restrict no. of characters

[matthewh]

Is there a way I can restrict no. of characters in a cell - I have a series of cells I need to restrict user input to 2 caracters, and one to 4 characters.

Tried it with LEN, but didn't work.

Thanks

[Aladin Akyurek]

On 2002-05-07 00:55, matthewh wrote:
Is there a way I can restrict no. of characters in a cell - I have a series of cells I need to restrict user input to 2 caracters, and one to 4 characters.

Tried it with LEN, but didn't work.

Thanks

Have a look at Data|Validation with Text length for Allow.

[anno]

On 2002-05-07 00:55, matthewh wrote:
Is there a way I can restrict no. of characters in a cell - I have a series of cells I need to restrict user input to 2 caracters, and one to 4 characters.

Tried it with LEN, but didn't work.

Thanks

i think you can do this with data validation (data menu). select 'text length' on the settings tab and less than or equal to 2, or 4 or whatever

[matthewh]

Thanks - I'll give it a try.