combine multiple excel values from an array back into a single excel cell comma separated

Question

I have multiple values that I'm reading into an array, but I need to paste those values into a single cell comma separated. Is this possible?

Dave · Accepted Answer · 2016-05-13 15:14:42Z

3

You can Join an array with a given separator

myArray = Array("John","Bob","Mary")     
sString = Join(myArray, ",")
msgbox sString

Will give you "John,Bob,Mary" in sString...

To put this into a cell: Worksheets("Sheet1").Range("A1").Value = sString

answered May 13, 2016 at 14:52

Dave

4,3562 gold badges26 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

edited to include cell set - just change cell and sheet name to match your own worksheet