Probably a Tab character.

Sub Remove_Tabs()
With Selection
.Replace what:=Chr(9), replacement:=Chr(32), _
lookat:=xlPart, SearchOrder:=xlByRows, _
MatchCase:=False
End With
End Sub


Gord Dibben Microsoft Excel MVP

On Fri, 26 Aug 2011 13:00:35 -0700 (PDT), GARY
wrote:

In some of the cells in my Excel spreadsheet, a small square character
is displayed. When I copy and paste it here, it looks like this:

" "

How do I replace this character with a space?