WE GOT A HIT!!!! I learned yet another thing... yes using number pad
allows data entry into FIND of ASCII Char() .

with number pad, entering 160 produces character that looks like an "a"
which my DOS book says is char(160) . Seems logical.

At first, when I entered 0160 into replace, I thought it didn't work.
then I noted that the was a blank space in the find field of the find
and replace dialog box. I then hit "replace all" and immediate all the
mysterious spaces were gone.

THANKS

Gord Dibben wrote:
Use the NumPad when entering the ALT + 0160

The regular number keys don't work for this method.


Gord Dibben MS Excel MVP

On Wed, 26 Jul 2006 10:42:39 -0700, windsurferLA wrote:

Thanks for super fast response by approach didn’t work. I forgot to say
I’m running XL97.

The replace or find would not accept any keyboard entries while the
alt-key way displayed. The machine beeps. I can’t enter 0160 while the
alt key is depressed.

Your approach seems to seek to enter the ASCII code for a special
symbol. I had been thinking along similar lines. I tried “^s” to
mimic the code one uses for paragraph “^p” and tab “^t” but it also did
not work. .

Any other ideas???

My immediate problem has been solved by my manually editing the 60
numbers, but I’d like to know what is going on for future reference.


Ron Coderre wrote:
Perhaps the "spaces" are really html non-breaking spaces.

Try something like this:

From the Excel main menu:
<edit<replace
Find what: Hold down the [Alt] key....type 0160...release the [Alt] key
Replace with: (leave this blank)
Click the [Replace All] button

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"windsurferLA" wrote:

I'm seeking to analyze data copied from stock broker on-line statement.
The values copy across as text with (what appears to be) a space
before and after each number. I can manually delete the spaces by
pressing F2 and the delete or backspace key as appropriate for the space
at the front and rear of the number which is otherwise of the form
-$123,456.00

The function Value() does not retrieve the value from the text stream.

The function Trim() does not remove the spaces.

The menu function, "replace" does not find the spaces when you use the
space bar to enter the item to be searched for.

Is there a special character that appears as a space but is not a space?