I am trying to write an array formula that is versatile to work a variable number of adjacent cells to be part of the array (click and drag to highlight is fine) but need to ensure each cell content is seperated with a comma then space before the next cell contents are included.
The issue I am having or trying to solve is that the concatenated content is from a variable number of adjacent cells. Which is why I was looking at array instead. but the seperator has to be a comma then space.
Any help for an excel dufus would be super appreciated....
The issue I am having or trying to solve is that the concatenated content is from a variable number of adjacent cells. Which is why I was looking at array instead. but the seperator has to be a comma then space.
Any help for an excel dufus would be super appreciated....