| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display or hide control characters in Excel 2007 | Excel Discussion (Misc queries) | |||
| How can I display control characters in Excel 2007? | Excel Discussion (Misc queries) | |||
| Suppress workbook display | Excel Programming | |||
| Label control - suppress GetFocus | Excel Programming | |||
| Can I suppress display of duplicate data in columns? | Excel Discussion (Misc queries) | |||
Hybrid Mode
