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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting characters 3
Excel Need Countifs Formula Help 0
count a character 1
Counting specific characters in a cell 2
Count Text Characters in cell 1
Count Characters in a cell 8
Count Characters in A Cell 3
Count specific characters in a cell 7

Back
Top