Suppress display of Print Control Characters

[AussieDave]

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.

 

[Peter T]

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

 

[Gord Dibben]

Set the cell to wrap text.


Gord Dibben MS Excel MVP