convert a List from a range to a single text cell
 

I would like to display the contents of a named range in a single cell
convert:

"List Item 1"
"List Item 2"
"List Item 3"
"List Item 4"

to

"List Item 1,List Item 2,List Item 3,List Item 4"

--
Fuzzy logix

convert a List from a range to a single text cell
 

J.E. McGimpsey shows a way:
http://www.mcgimpsey.com/excel/udfs/multicat.html

blayne wrote:

I would like to display the contents of a named range in a single cell
convert:

"List Item 1"
"List Item 2"
"List Item 3"
"List Item 4"

to

"List Item 1,List Item 2,List Item 3,List Item 4"

--
Fuzzy logix

--

Dave Peterson