I have one row with 100's of e-mail addresses seperated by a ;

How do I create a new row automatically in place of or directly after the ; - so each address is on a new row (for imnporting into mail program)?

Thanks.