|I assume that the email addresses are in one cell. |
You should be able to start with the Text To Column feature. Choose "delimited" and use the semi-colon as your delimiter character. That should separate the emails addresses to columns.
Now select the email addresses and do a Copy...PasteSpecial...Transpose to change the columnized data into rows.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.