Sorry for not being clear.

What I meant is that after I ran your code there is no comma seperating the text in the results.

After the vba is run i would like there to be commas between the values like in the example where they are highlighted in red.
('AFG', 'FKFKF', 'DDJ', 'DKKFJG', 'DKDKJDJF'),


thanks for all your help and taking the time to write the code. I do appreciate it.

I have 29,300 records that need to have brackets and quotes and commas entered so the code is saving me an enormous amount of time.