Replace weird character

  • Thread starter Thread starter GARY
  • Start date Start date
G

GARY

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?
 
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
 
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





- Show quoted text -
Click to expand...

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