I am creating a file with sqr. A chr(10) --- which is supposed to be a line
feed --- not only does a line feed but also a carriage return. How do I set
the format of a cell in an sqr?

"Roger Govier" wrote:

Hi

Try
=A1&CHAR(10)&A2&CHAR(10)&A3&CHAR(10)&A4
Set the format of the cellalignmentWrap text

--
Regards

Roger Govier


"Bretter99" wrote in message
...
For example: =concatenate(a1,a2,a3,a4) = ILIKEBEEFBURGERS, But I want
it to
put the result into a single excel cell like this:
I
LIKE
BEEF
BURGERS

But i cant see how to manually insert a line break into my statement
as in
something like:
=concatenate(a1,<line break,a2,<line break,a3,<line break,a4,<line
break,)
Any suggestions would be appreciated, thanks :P