"Jeff" wrote:
Your formula worked good, but I still have probems. See my post ..

Another question: Cells D4, I4, J4, K4 may sometimes be empty. When they are
empty - I prefer those lines to not appear...

One way would be to IF front-check all the said cells, then apply the
earlier expression with the parts referring to the said cells removed from it
as value_if_TRUE, then with the original expression applied as the
value_if_FALSE.

Eg, in N4, copied down [with N4 formatted to wrap text, as before]:
=IF(AND(D4="",I4="",J4="",K4=""),CONCATENATE(A4,"; ","
",B4,CHAR(10),C4,CHAR(10),E4," ",F4,",","
",G4,CHAR(10),H4,CHAR(10),L4,CHAR(10),TEXT(M4, "m/dd/yy")),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")))

By the way, what does "AFAIK" mean?

AFAIK = As far as I know

Are you saying that it is not possible
to make some characters bold?

Yes. Formulas cannot return formatting (even more "partial" formatting)

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---