ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Display a value in a column (https://www.excelbanter.com/excel-programming/381504-display-value-column.html)

Darin Kramer

Display a value in a column
 
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

Display a value in a column
 
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 ***




Darin Kramer

Display a value in a column
 


Thanks!! Doesnt need to be pretty!

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


All times are GMT +1. The time now is 07:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com