How to copy / paste email addresses into each cell in the spread sheet?

We are using Outlook for email. For intra-office memo, we have long list of
email addresses in different project groups and different discussion /
meeting groups of distribution list.
Typical Outlook email address in the cc: list string we can copy / paste
from is like this
'; '; '; ';

How can I copy the entire string and paste these email addresses into
each individual cell in the spread sheet? I would like each email address
pasted in one cell of its own. Can you please tell me how to do it?

Thank you.