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
Bookmarks