Formula to count characters in a cell

  • Thread starter Thread starter Christop
  • Start date Start date
C

Christop

I would like to enter a formula which will show me how
many characters I've typed in a cell, as I need to keep
the number to no greater than 15 and would like to see
quickly how many I've exceeded by or have available.

Thankyou in expectation

Chris
 
=LEN(A1)

You could also data validate the cell using something like...

=LEN(A1)<=15

as custom formula.
 
Back
Top