How to concatenate range cells with comma, space, line break in Excel
This article is talking about concatenating a row/column into one cell with separating by comma or space, as well as concatenating a range into one row/ column/cell with separating each cell content by any kind of separators, such as comma, space, line break, etc. in Excel.
More details:
https://www.extendoffice.com/document...
