A
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.
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.