An interesting challenge....Part Two!

[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

 

[DDM]

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

=LEN(C6)

 

[Guest]

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

 

[danison]

Hi

Thanks for that. Must have missed it between times I checked

cheers

Bil