How do I convert a column to a comma separated list in Excel?

Question

1. Select a blank cell adjacent to the list's first data, for instance, the cell C1, and type this formula =CONCATENATE(TRANSPOSE(A1:A7)&",") (A1:A7 is the column you will convert to comma serrated list, "," indicates the separator you want to separate the list).

How do you convert a list to a comma separated value?

Approach: This can be achieved with the help of join() method of String as follows.1Get the List of String.2Form a comma separated String from the List of String using join() method by passing comma ', ' and the list as parameters.3Print the String.

How do I concatenate a list in Excel with commas?

Combine data using the CONCAT function1Select the cell where you want to put the combined data.2Type =CONCAT(.3Select the cell you want to combine first. Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text.4Close the formula with a parenthesis and press Enter.

How do I create a delimited list in Excel?

Create a drop-down list1Select the cells that you want to contain the lists.2On the ribbon, click DATA > Data Validation.3In the dialog, set Allow to List.4Click in Source, type the text or numbers (separated by commas, for a comma-delimited list) that you want in your drop-down list, and click OK.

Expert · Answer