Display a value in a column

's Computer Specifications

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

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 ***

's Computer Specifications

Thanks!! Doesnt need to be pretty!

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Display index of column headers in column A	MZ	Microsoft Excel Misc	9	17th Jan 2010 06:35 PM
Display column when previous column contains data	MPSingley@midamerican.com	Microsoft Excel Programming	1	3rd Jan 2007 03:01 PM
Based on a condition in one column, search for a year in another column, and display data from another column in the same row >> look	MPSingley@midamerican.com	Microsoft Excel Programming	2	30th Dec 2006 06:23 PM
Based on a condition in one column, search for a year in another column, and display data from another column in the same row >> look	MPSingley@midamerican.com	Microsoft Excel Misc	0	27th Dec 2006 04:31 PM
Display missing Part Number if Column A does not match column B	=?Utf-8?B?RXJpayBU?=	Microsoft Excel Worksheet Functions	2	17th Apr 2006 11:23 PM