I know nothing about a Mac

Sorry, Gord

On Sun, 22 Mar 2009 12:35:01 -0700, sorrywm
wrote:

This didn't work, but it's possible that's because my computer is a Mac. Do
you know if there is a different way to do Alt+0160 on a Mac? I've tried
option, ctrl, fn, and the apple key, none of which worked, but maybe there's
some combination that will work.

"Gord Dibben" wrote:

Web data lotsa times has non-breaking spaces 0160

Try edit replace and in the what: dialog hold Alt key and hit 0160 on the
numpad.

In the with: dialog enter nothing


Gord Dibben MS Excel MVP


On Sun, 22 Mar 2009 10:14:01 -0700, sorrywm
wrote:

There are no spaces in my data. Find/Replace gave me an error message saying
there was nothing to replace.
I'm not sure whether anyone will be able to determine anything from playing
with the data, because the copy-paste issue (I'm fairly sure that's what it
is) might not happen on other people's computers. But it's worth a shot:
87 8 46
69 27 99
85 27 91
64 1 26
76 25 97

"Shane Devenshire" wrote:

Hi,

1. To verify what is going on select on of the cells and then click the
Formula Bar - are there spaces before or after the number on the formula bar?
Most likely yes.

2. These may or may not be "spacebar spaces". Here is what I usually do,
highlight the entire range of numbers and press Ctrl+H. In the Find what box
type a single space, leave the Replace with box empty. Press Replace All.
This will get all the regular spaces, but others may remain. You can repeat
step 1 to verify if there are other types of spaces.

3. If there still are some spaces, select one of cells and click on the
Formula Bar, highlight a single space on the Formula Bar and copy it. Press
Esc once. Press Ctrl+H, select the contents of the Find what box and choose
paste. This will replace the regular space with the character you copied
from the cell. Click Replace All.

4. Hopefully this will clear up the problem. If not you need to post a
sample of the data. So we can see what you really have.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"sorrywm" wrote:

I copied some data into an Excel (2004) spreadsheet from the web, and now I
can't operate on the cells, despite the fact that their format is 'Number.'
I've tried re-copying the cells and paste-special-ing 'Value,' but to no
avail. Does anyone know how to make Excel recognize these perfectly good
numbers?