Adjustments to concatenation

  • Thread starter Thread starter Steven
  • Start date Start date
S

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
 
Hi Steven,

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

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

Biff
 
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


.
Click to expand...
 
Back
Top