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
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.