David McRitchie has a macro that cleans up this kind of stuff:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall
(look for "Sub Trimall()"

If that doesn't work...

Chip Pearson has a very nice addin that will help determine what that
character(s) is:
http://www.cpearson.com/excel/CellView.htm

Since you do see a box, then you can either fix it via a helper cell or a macro:

=substitute(a1,char(13),"")
or
=substitute(a1,char(13)," ")

Replace 13 with the ASCII value you see in Chip's addin.

Or you could use a macro (after using Chip's CellView addin):

Option Explicit
Sub cleanEmUp()

Dim myBadChars As Variant
Dim myGoodChars As Variant
Dim iCtr As Long

myBadChars = Array(Chr(10), Chr(13)) '<--What showed up in CellView?

myGoodChars = Array(" ","") '<--what's the new character, "" for nothing?

If UBound(myGoodChars) < UBound(myBadChars) Then
MsgBox "Design error!"
Exit Sub
End If

For iCtr = LBound(myBadChars) To UBound(myBadChars)
ActiveSheet.Cells.Replace What:=myBadChars(iCtr), _
Replacement:=myGoodChars(iCtr), _
LookAt:=xlPart, SearchOrder:=xlByRows, _
MatchCase:=False
Next iCtr

End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

V-ger wrote:

When copying a table from Word (2000) into Excel (XP) it converts the numbers
to text so that formulas do not work. The Formula is fine, but the numbers
are seen as text. If I click on one of the number cells, then on the formula
bar, and at the beginning of the content hit backspace, it turns to a number
again, but there is NO SPACE there, must be some other hidden code or
something. I used to get a button that asked if I wanted to insert as text
or numbers, but a tech turned that function off and now it just pastes as
text. How can I get it to ask me again if I want to paste (from Word 2000)
numbers or text? Or better yet, just always paste numbers as numbers by
default?

Any solutions? Please help. Thank you!

--

Dave Peterson