| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I count cells with text but ignore cells with spaces?
I have a form that users enter names in a column and I need to count them.
Unfortunately some users simple hit the space bar to delete a name instead of using the clear or delete key. In those cells, with spaces now which appear to be blank, the cell is treated like it has text in it when I use the counting functions. Any suggestions on how I count the names only and ignore the cells that are blank and the cells with just a couple of spaces in them? What do you think? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum multiple cells with different numbers and text. | Excel Discussion (Misc queries) | |||
| HOW DO I COUNT CELLS WITH DATA BY COLUMN? | Excel Worksheet Functions | |||
| How do I count cells with text in them? | Excel Discussion (Misc queries) | |||
| count cells containing text | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Threaded Mode
