How to convert a column to a comma separated list in Excel 2016 ?

In this blog post , we will share a simple tips in excel 2016 where you can convert a column to a comma separated list.

How to convert a column to a comma separated list in Excel 2016 ?

Assume that you have a column "A" in excel that contains the following items

789
6576
567

You need to convert it to a comma-separated list and display it in another cell of the worksheet like 789,6576,567.

To do it , follow the below steps.

1. Select the Column B1 and then enter the following formula =A1.

2. Similarly , select the column B2 and enter the following formula =B1& "," &A2.

3. Copy the content of B2 and paste it in the below cell.

4. You should see the comma separated list in the last column selected as shown below.

image

Leave a Reply