Excel 2002: How to eliminate space within a cell and count items?

M

Mr. Low

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
 
B

Bernard Liengme

You could use Edit | replace to change the actual data
or to get the required data in a new cell use =SUBSTITUTE(A1," ","")
that double-quotes with and without a space between them
best wishes
 
S

Stefi

Question 2:
Right click on the status bar (bottom edge of Excel window), select Count
from the local menu!

Regards,
Stefi

„Bernard Liengme†ezt írta:
 
G

Gord Dibben

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
 
M

Mr. Low

Hello Bernard,

Your =SUSTITUTE( ) formula works very well.

It is goinfg to be very helpful for my daily tasks in the future.

Many thanks

Low
 
M

Mr. Low

Hello Stefi,

Many thanks for your info.

It is going to be very helpful for my daily office work in the future.


Kind Regards

Low
 
M

Mr. Low

Hello Gord,

Many thanks for your information.

It is going to be very helpful for my daily office work in the future.


Kind Regards

Low
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top