ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Selected items (eg count) does not show up on status bar (https://www.excelbanter.com/excel-discussion-misc-queries/200743-selected-items-eg-count-does-not-show-up-status-bar.html)

Patti Bowles

Selected items (eg count) does not show up on status bar
 
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

Kevin B

Selected items (eg count) does not show up on status bar
 
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



All times are GMT +1. The time now is 08:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com