An interesting challenge....Part Two!

D

danison

Hi

further to my earlier post there was a query I think may have bee
missed, and would appreciate someone's advice on it.

If I am using 'Data, Validation, Allow Text' to ;imit the number o
characters I am putting into a cell, is there some way to have Exce
auto calculate and detail the number of characters in the cel
alongside the cell?

Thanks

Bil
 
D

DDM

Danison, you did get an answer to your second question in your earlier post.
Here it is again:

=LEN(C6)
 
U

unlikeKansas

I did reply to your earlier post.

Try =Len(A1), where A1 is the cell that contains the characters that you wish to count


----- danison > wrote: -----

Hi

further to my earlier post there was a query I think may have been
missed, and would appreciate someone's advice on it.

If I am using 'Data, Validation, Allow Text' to ;imit the number of
characters I am putting into a cell, is there some way to have Excel
auto calculate and detail the number of characters in the cell
alongside the cell?

Thanks

Bill
 
Top