On Aug 26, 1:52*pm, Gord wrote:
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?- Hide quoted text -

- Show quoted text -

Why can't I used Find and Replace to eliminate the character?