Removing Chr(10)

[Daniel Bonallack]

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

[MH]

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" <DanielBonallack@discussions.microsoft.com> wrote in
message news:D271F9B3-DF77-4B51-84F4-6D96B6F25DD5@microsoft.com...
> 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