Adjustments to concatenation

[Steven]

If I am typing in a cell and put: 'This is the First
Row' and then hit Alt+Enter and then 'Second Row' and
Alt+Enter and 'Third Row' I will get:

This is the First Row
Second Row
Third Row

all in the same cell.

How can I take input from 3 different cells example:
Cell A1 = This is the First Row
Cell B1 = Second Row
Cell C1 = Third Row

In D1 I want to concatenate A1 B1 and C1 and end up with
the results all in D1 but in seperate lines as in the
example above.

Thanks for your help.


Steven

 

[Biff]

Hi Steven,

Try this: Format D1 for word wrap.
Format>Cells>Alignment>Wrap Text

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

Biff

 

[Ken Wright]

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

and format the cell D1 as 'Wrap text'

 

[Steven]

Thank you. I was trying Chr(13) in error.

-----Original Message-----
=A1&CHAR(10)&B1&CHAR(10)&C1

and format the cell D1 as 'Wrap text'

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

---------------------------------------------------------- ------------------
Attitude - A little thing that makes a BIG difference
---------------------------------------------------------- ------------------






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003


.