Concatenate with carriage returns

[neopolitan]

I have the following data layout:

A1 B1 C1
Name Address City

I would like to concatenate these and include carriage returns so tha
the result looks like this:

D1
Name
Address
City

I don't know how to get the concatenate function to recognize th
carriage return.

Any help

 

[RagDyeR]

Try this:

=A1&CHAR(10)&B1&CHAR(10)&C1

Don't forget to format D1 to "WordWrap", otherwise, the Char(10) will
display as small squares!
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I have the following data layout:

A1 B1 C1
Name Address City

I would like to concatenate these and include carriage returns so that
the result looks like this:

D1
Name
Address
City

I don't know how to get the concatenate function to recognize the
carriage return.

Any help?

 

[Peo Sjoblom]

=A1&CHAR(10)&B1&CHAR(10)&C1

turn on wrapping under format>cells>alignment and check wrap text

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)