Replace weird character
 

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?

Replace weird character
 

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?

Replace weird character
 

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?

Replace weird character
 

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?

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