Hi,

How about

=A1&","

Then double click the little black square in the bottom right hand corner of B1, this will auto-fill down provided you have your text in column A