Would you explain the necessity of Char(13)?

I don't see any need for it at all!

All it gives me is an additional character (square) after the contents of
A1.

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Vergel Adriano" wrote in message
...
Use CHAR(13) and CHAR(10) to insert a new line. For example, this will
concatenate the contents of A1 and B1. B1 will be on the line below A1.

=CONCATENATE(A1,CHAR(13),CHAR(10),B1)

Note that you need to turn on "Wrap text" for the cell. (Format-Cells,
in
the Alignment tab, check "Wrap text").




"Alphafiction" wrote:

I'm trying to insert a break at a particular point in text that is
combined
using concatenate. The text is being used as column headings and I was
hoping
to have some consistency in appearance to make the information easier to
read. The length of the pieces of combined text are of differing lengths.
The
column widths are generally the same but do occasionally vary.

Any ideas?