Forcing Carriage Returns (or New Line)...

[Al Gillis]

Hi Sportsfans...



Using Excel 2003 I've got:

Cell A1: Last Name, First Name

Cell A2: Street Address

Cell A3: City, State ZIP



Each data element is in a cell of its own but on different lines.



I want to combine those data elements so they are all in one cell and yet
maintain the line to line spacing of each element.



I've tried using the Concatenate command (as in =concatenate(A1,A2,A3) and
the "&" command (as in =A1&A2&A3. Both these result in strings like this:



Cell A4: Last Name, First NameStreet AddressCity, State ZIP



Notice that the individual lines are run together (e.g. "Street" is slammed
against the e in "Name"). The appearance of this result is dependant on the
column width, of course.



What I want the result to be should look like:



Cell A4: Last Name, First Name

Street Address

City,State ZIP



(Cell A5 would be vacant or contain other, unrelated data)



I've tried to force "carriage returns" into the concatenate and & commands
(for example, =concatenate(A1,char(013),A2,char(013),A3,char(013),A4) but
that only puts little rectangles in the text string, not new line functions.



Anyone have a clever but simple way to do this?



TIA, Al.

 

[Dave Peterson]

=a1&char(10)&a2&char(10)&a3

You'll have to turn wrap text on (format|cells|alignment tab) and you may have
to widen the column.

 

[Al Gillis]

Of course! A Line Feed code (10) - not a carriage return (13)!

I guess my old Teletype and serial printer skills got the best of me!

Thanks, Dave!