You could use

Note that the curly brackets indicate an Array formula DO NOT type them
simply type


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

Change the range to suit



"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