Counting & Displaying

H

Henn9660

I would like to count the number of characters in a given cell and then be
able to have a display "in your face" telling you how many characters you
have remaining for the particular cell.

In my case, I have a total of 6 COMMENT-type cells. The first one has a
validation max of 250 characters and the other five have a max of 150
available.

Having looked over previous inquiries, I can find out how to count 'words',
but none refer to counting characters.

In advance, thanks!
Jeff Hennessey
 
A

akphidelt

You should be able to right a formula like

Assuming data is in cell A1

=250-LEN(A1)

LEN gives you the amount of characters in a cell
 

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

Maximum characters in cell 2
Counting assistance 3
Macro to count characters with specific formatting 0
If Condition Confusion 3
text exceeds allowed number of characters per cell 1
Counting one Character as a String 1
VLOOKUP, a table with text and numerics 7
Counting question 16

Top