Need to add delimiters before and after a value

[dmfweb]

I have what I feel like should be so simple, but I can't get it to work. I have tried =TEXTJOIN, but can't get it to quite work right since there are multiple delimters.
I have a list of serial numbers (about 1500) and I need to add a " before the value and a " after the value and then a , at the end. (that is a quotation mark before and after and a comma after)
So, if this was my list

1
2
3
4
5

I would end up with : "1", "2", "3", "4", "5"

Any thoughts?

 

[Cubist]

Try:

Book1
	H	I
1	1	"1", "2", "3", "4", "5"
2	2
3	3
4	4
5	5
Sheet3

Cell Formulas
Range	Formula
I1	I1	=TEXTJOIN(", ",,""""&H1:H5&"""")

 

[dmfweb]

Try:

Book1
	H	I
1	1	"1", "2", "3", "4", "5"
2	2
3	3
4	4
5	5
Sheet3

Cell Formulas
Range	Formula
I1	I1	=TEXTJOIN(", ",,""""&H1:H5&"""")

I am not sure if I want to tell you I love you hate you for solving this so quickly.... lol but either way... Thank you VERY much. That worked