-1

I have one column with items for example:

Column A:
item1
item2
item3
item4
item5
item6
item7
item8 
..

All I would like to have one cell with text like: cell B1 = "item1, item2, item3, item4, item5, item6, item7, item8". So every cell from Column A should be placed in one cell.

The problem is that sometimes i have 100 items. Please give me some smart advice :D

damianm
  • 121
  • 1
  • 8
  • Which version of Excel are you using? – G42 Mar 04 '18 at 17:23
  • 2
    Possible duplicate of [How to merge rows in a column into one cell in excel?](https://stackoverflow.com/questions/8135995/how-to-merge-rows-in-a-column-into-one-cell-in-excel) – Sardar Usama Mar 04 '18 at 17:26
  • What have you tried? And what has been the problem with what you 've tried? How does it differ from other, similar problems already with answers here on SO? – Ron Rosenfeld Mar 04 '18 at 18:18

1 Answers1

2

In B1 enter:

=TEXTJOIN(", ",TRUE,A:A)

enter image description here

Gary's Student
  • 95,722
  • 10
  • 59
  • 99