For 2.

Right-click on the status bar and select "count" from the options.

This will count all cells selected, not just text cells.

Count Nums will count all cells with numbers.


Gord Dibben MS Excel MVP


On Thu, 23 Nov 2006 06:32:01 -0800, Mr. Low
wrote:

Dear Sir,

1. May I know how to eliminate the spacing within a cell as follows :

Before eliminating After eliminating
AAB 8426 AAB8426
AAC 6542 AAC6542


2. Also in Excel 2002, the when a block of cell containing numbers is
highlighted, it sum total appears at the right hand bottom of the screen
without displaying the number of items added.

Is there anyway I can customized this function to show n items when the
cells are highlighted ? or is there any other keyboard shortcut of doing
this ? Can the worksheet count the number of text items (n) highlighted in
a column ?

For example :

Column A
ABC2111
ACC2112
ACD2145 , n =3


Thanks

Low