View Single Post
  #4   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Dmitry Dmitry is offline
external usenet poster
 
Posts: 32
Default Why does not Excel 2003 Replace comand romove spaces from cell contents?

Thanks Pete!
The Replace does not remove a space after a number in a cell. The cells are
in the text format.
"Pete_UK" ???????/???????? ? ???????? ?????????:
oups.com...
Replace should remove spaces - highlight your cells then CTRL-H. In the
"Find What" panel enter a single space, in the "Replace With" panel
leave this empty, then click Replace All and your spaces should have
gone.

If you have spaces after a number in a cell (and therefore the cell
contains text), you can convert it to a number in another cell by means
of:

=VALUE(A1)

and copy this down if necessary.

Hope this helps.

Pete