Replace weird character

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

 

[Gord]

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

 

[GARY]

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 -

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

 

[Ron Rosenfeld]

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?

Copy the character
Find/Replace
Find What: Paste in your character
Replace: <space>