Try in say, N4:
=CONCATENATE(A4,";"," ",B4,CHAR(10),C4,CHAR(10),D4,CHAR(10),E4," ",F4,",","
",G4,CHAR(10),H4,CHAR(10),I4,CHAR(10),J4,CHAR(10), K4,CHAR(10),L4,CHAR(10),TEXT(M4,"m/dd/yy"))

Then format N4 to wrap text
(via: Format Cells Alignment tab Check Wrap Text OK)
Copy N4 down

I also want "Aukes;" to be bold. That would be [A4].

AFAIK, not possible ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jeff" wrote:
Here is my formula:
=CONCATENATE
(A4,";"," ",B4," ",C4," ",D4," ",E4," ",F4,","," ",G4," ",H4," ",I4," ",J4,"
",K4," ",L4," ",M4)

Returns:
Aukes; Jeff & Andrea 6812 321st Lane NE Apt #310 Stacy MN, 55079 (651)
462-5716 (651) 462-2803 Michael Ashley Member - Active 5/17/06

I want it to appear on separate lines (but in one cell) as showen below:

Aukes; Jeff & Andrea [A4, B4]
6812 321st Lane NE [C4]
Apt #310 [D4]
Stacy MN, 55079 [E4, F4, G4]
(651) 462-5716 [H4]
(651) 462-2803 [I4]
Michael [J4]
Ashley [K4]
Member - Active [L4]
5/17/06 [M4]

I also want "Aukes;" to be bold. That would be [A4].
Is this possible?