Need help on merging

[Harini1100]

Hello Team,

I need a formula to combine the list of data into one cell which "," separator

 

[jbodel]

Can you use =Concatenate? So = concatenate(A2,",",A3,",") etc. The comma's between each double quote will put a comma between each input.

 

[dreid1011]

If you're using 365, try this:

Book1
	A	B
1	123	123,456,789,101,202,303
2	456
3	789
4	101
5	202
6	303
Sheet1

Cell Formulas
Range	Formula
B1	B1	=TEXTJOIN(",",,A1:A6)