Display a value in a column

[Darin Kramer]

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 ***

 

[Bernard Liengme]

It isn't pretty but it works:
=E1&F1&G1&H1&I1&J1&K1&L1&M1
best wishes

 

[Darin Kramer]

Thanks!! Doesnt need to be pretty!

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