Another way to get rid of the non breaking space is
to use Find and Replace

Select your data
Go to EditReplace
Find what: Alt+0160
Replace with: (leave this blank)
Click Replace All

(To use unicode hold down the Alt key type 0160 on the
number pad only, then release the Alt key.)

HTH
Martin


"scubadiver" wrote in message
...

I used to text-to-columns.




"scubadiver" wrote:


I have copied some information from a website into Excel and a column of
numbers have been formatted as text (though not another column oddly
enough)

I have tried using the recommendations I have found on this board but it
still won't work.

thanks