Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing Chr(10)
Hi am trying to get rid of the little box that shows up when you view with
"Wrap Text" turned off. My download contains thousands of them. Previously I've found it easy with: Selection.Replace What:=Chr(10), Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False But on one sheet, this has no affect, like Excel just ran out of memory. Some of the cells contain more than 255 characters - is this the problem? Thanks in advance for any help Daniel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing Chr(10)
You probably need to find/replace using Chr(13) as well, some files use a
carriage return/Linefeed pair instead of one or the other. MH "Daniel Bonallack" wrote in message ... Hi am trying to get rid of the little box that shows up when you view with "Wrap Text" turned off. My download contains thousands of them. Previously I've found it easy with: Selection.Replace What:=Chr(10), Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False But on one sheet, this has no affect, like Excel just ran out of memory. Some of the cells contain more than 255 characters - is this the problem? Thanks in advance for any help Daniel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
removing na | Excel Discussion (Misc queries) | |||
Removing text between hyphens and removing the hyphens | Excel Discussion (Misc queries) | |||
Removing #N/A | Excel Discussion (Misc queries) | |||
Removing patterns without removing gridlines | Excel Discussion (Misc queries) | |||
Removing the +4 from zip+4 | Excel Discussion (Misc queries) |