Character Count Range of Cells

[michimac]

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

[michimac]

Works perfectly. Thanks!
--
michimac


"Naz" wrote:

> 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