Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Character search and replace | Excel Worksheet Functions | |||
Replace nonprinting character | Excel Worksheet Functions | |||
replace new line character | Excel Discussion (Misc queries) | |||
demial number being replace by a square box...weird | Excel Discussion (Misc queries) | |||
How do I replace a character with another? | Excel Discussion (Misc queries) |