Suppress display of Print Control Characters
 

I'm using Chr(10) to split lines within a single cell and these are
displaying as a small box. How do I suppress this display but keep
the separate lines within the cell? Thanks in advance, Dave.

Suppress display of Print Control Characters
 

Normally a single Chr(10) or vbLf is just what you do want. My guess is
that square is more likely due to a Chr(13) or vbCr.

Regards,
Peter T


"AussieDave" wrote in message
...
I'm using Chr(10) to split lines within a single cell and these are
displaying as a small box. How do I suppress this display but keep
the separate lines within the cell? Thanks in advance, Dave.

Suppress display of Print Control Characters
 

Set the cell to wrap text.


Gord Dibben MS Excel MVP

On Sun, 29 Jun 2008 20:26:50 -0700 (PDT), AussieDave
wrote:

I'm using Chr(10) to split lines within a single cell and these are
displaying as a small box. How do I suppress this display but keep
the separate lines within the cell? Thanks in advance, Dave.