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



--
A36B58K641


"Bernard Liengme" wrote:

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

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Mr. Low" wrote in message
...
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

--
A36B58K641