Character count and locking?

L

Liani

I would like to set up a formula that does a character count of info in a
cell and then lock that cell so that the info cannot go over 33 characters.
 
I

ivan.raiminius

Hi Liani,

You can count characters by this formula: =len(a1)

It is not possible to lock cell with formula, you can do it via VBA
sub.

Regards,
Ivan
 
S

starguy

you can use data validation to restrict data with more than 33
characters.

select the range you want to enter the data in.

go to Data > Validation

Settings > in Allow (text length) and in Data (less than) and in
Maximum put 33 or whatever length you want.

hope this would be solution of your question.
 
Top