Excel formula for comma separated values

In easy learning blog i am showing steps by step to get comma separated values in excel application.

  1. Create a list of values in column A.
  2. Select cell B1.(first cell of column B.)
    = A1
  3. type the below formula in cell B2.
    = B1 & “,” &A2
  4. Select right bottom of cell B2 and drag vertically down till end of data.
  5. The last cell in column B should now be a comma separated list of column A.
  6. Copy the last cell data to notepad and use it where you wish to use.

Step 2. Image Reference

Step 3. Image Reference

This formula will be helpful when you have provide the value as comma separated or combining data with some delimiter’s.