Character Count Range of Cells
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
|