Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to get the character count on a cell. In the status bar I have
slected count but nothing shows up on the status bar, so i tried them all and the only ones that show up are the zoom and macro record butoon |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
To get the character count you need to use the LEN function.
In a blank cell type the following substituting the cell you want to count characters in: =LEN(A1) The function returns a count of each character in the cell. The count function on the status bar counts the number of entries in a selected range, not the specific character contents of a cell. Hope this helps. -- Kevin Backmann "Patti Bowles" wrote: I am trying to get the character count on a cell. In the status bar I have slected count but nothing shows up on the status bar, so i tried them all and the only ones that show up are the zoom and macro record butoon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
EXCEL allow 2 options on status bar e.g. show "Count" + "Sum" | Excel Discussion (Misc queries) | |||
Print Pivottable - show all selected items in page filter | Excel Discussion (Misc queries) | |||
On status bar, sum of selected cells doesn't automatically appear. | Excel Discussion (Misc queries) | |||
Excel Status Bar items | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) |