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


"michimac" wrote:

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.
--
michimac