It isn't pretty but it works:
=E1&F1&G1&H1&I1&J1&K1&L1&M1
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Darin Kramer" wrote in message
...
Hi There,

Columns E through M are either blank or have a single text entry in a
cell, (ie one text entry per line in one of the columns) I want to
display the single text entry in column N. Any ideas....??

Thanks

D



*** Sent via Developersdex http://www.developersdex.com ***