Generate single cell listing from a column of email addresses

I have an Excel sheet listing of club members (varies between 30 and 60 each year) with one column containing all email addresses. I would like to automatically generate a text listing in one cell by adding each email to it with a semi-colon separating each address. My purpose is to create an email address list that my email program will accept. Example follows -

[email protected]
[email protected]
[email protected]

combine these to produce text list in one cell -

[email protected]; [email protected]; [email protected]



Richard