convert a List from a range to a single text cell

G

Guest

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need ONLY subtotals copied to a second sheet 4
How to use Sumifs with vertically and horizontally criterias 3
Find string from column A in Range("B2:F7") list the header of that column/s 5
list box remove item by combobox 4
Convert code to lookup three criteria return fourth 15
List of Displayed Pivot Items 1
Hard-Coding Vs Coding for Dynamic Header 0
Copy Application.Union(c.Offset(0, 1), c.Offset(0, 2)... to a list onsame & another sheet 27

Top