| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count the number of times a letter is used in a cell? | Excel Discussion (Misc queries) | |||
| count each cell that have a number and take that number and count. | Excel Discussion (Misc queries) | |||
| Cell Count | New Users to Excel | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| how to count the number of decimal places in a cell? | Excel Worksheet Functions | |||
Threaded Mode
