Concatenate with carriage returns

  • Thread starter Thread starter neopolitan
  • Start date Start date
N

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
 
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?
 
=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)
 
Back
Top