count the number of caracters in a cell
Jan wrote:
How can I count the number of caracters including spaces in a microsoft excel
worksheet
On a worksheet?
Try:
=SUM(LEN(Sheet1!1:32768))+SUM(LEN(Sheet1!32769:655 36))
This is an array formula, press Ctrl+Shift+Enter to enter it.
Put the formula on a different sheet to the one you want to count so
that you don't get a circular reference.
And it takes a long time to run - be warned.
Regards
Steve
|