View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
 
Posts: n/a
Default 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