Forum Discussion

Copper Contributor

Jan 15, 2020

Solved

Cell Limits

I have a limited amount of space (30 characters including spaces) to use for populating a drawing description. I want to create a sheet that I can give to someone so they can see exactly what I have ...

excel

Riny_van_Eekelen
Jan 15, 2020
T_Dawg69
Perhaps not "live". But, as an example, when your description is in A1, you could type

=LEN(A1)

..... in the cell next to it to display the number of characters (= length) in A1 as soon as one presses Enter. You don't really need it, though, as the validation will not accept anything longer than 30 characters.

Riny_van_Eekelen

Platinum Contributor

Jan 15, 2020

T_Dawg69

You can validate the input in the description field. Choose the range (or an entire column). Then in the top menu, "Data", "Validation...". Then choose "Text length"," less than or equal to", "30". Like in the picture below.

Taken on a Mac, but I'm confident that it looks similar on a PC.

T_Dawg69
Copper Contributor
Jan 15, 2020
Riny_van_Eekelen
I have a data tab but i do not see an option for validation?
- Riny_van_Eekelen
  Platinum Contributor
  Jan 15, 2020
  T_Dawg69
  Yes you do. See the red arrow in attached picture.
  But in the top menu you should have Data as well. There you can also find "Validation...". Ribbons (tabs) are customisable and my not look the same for all.
  - T_Dawg69
    Copper Contributor
    Jan 15, 2020
    Riny_van_Eekelen
    Maybe.........I need to get my glasses checked....LOL. Thanks!
    
    Next part. . . is there a way to show "live" the character count as they are being typed?
    
    Thanks again