Character Count Range of Cells

[Guest]

How can I get a character count for text in a large range of cells in a
worksheet? I can only get LEN to count a single cell without a #VALUE!
error.

 

[Guest]

Works perfectly. Thanks!
--
michimac

You could use

{=SUM(LEN(A1:A20))}
Note that the curly brackets indicate an Array formula DO NOT type them
simply type

=SUM(LEN(A1:A20))

and the prest Ctrl+Shift+Return the formula will be entered and the
brackets as well.

Change the range to suit



--

_______________________
Naz,
London