View Single Post
  #5   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?

Yes, I've imported my numbers from the web. Thank you Ron Rosenfeld very
much!
"Ron Rosenfeld" ???????/???????? ? ????????
?????????: ...
On Thu, 6 Apr 2006 16:15:28 +0400, "Dmitry" wrote:

Hello
Why does not Excel 2003 Replace command remove spaces from cell contents?

Is
there any other way than the trim function to remove spaces after numbers

in
cells?


I'll guess from the incomplete information you've posted, that you've

imported
your numbers from an HTML source (i.e. the web) and what you think is a

<space
is really a <non-break-space

That being the case, in the Find box of the Replace command, try entering

the
nbsp code -- hold down <alt and, from the numeric keypad, type 0160; then
release the <alt button. Leave the Replace box blank.


--ron