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.