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