Count results, add punctuation

Hi Guys

This is more of a theory question than something I have in practice.

Basically say I had 4 names stored in a database and I wanted to print them, how could I print them with a comma between the 1st three and then and ampersand before the last result?
So name1, name2, name3 & name4

Also if the count is just one result, how could you print just name1 without any punctuation symbols??

Using Excel 2010 VBA

Cheers