I have thousands of emails separated by commas, looking for a formula..

Hello EF,

This is what I have...

Thousands of emails in this format..

example@gmail.com;example@gmail.com;...mple@gmail.com;

Spread into 5 cells. In the first column, the first 5 rows is where all these emails are. They are in the first 5 cells.

It looks like this http://gyazo.com/2bc6aa7407fd6a28f8216b67ac2da417

I'm looking for a formula which will...

Separate all of these emails so they are stacked in 1 column & in individual cells like this format..

example@gmail.com;
example@gmail.com;
example@gmail.com;
example@gmail.com;
example@gmail.com;

Can anyone help me? Thanksss