spearate names from list

[freud1]

Hi Guys,

Please see th esheet attached. (all names used are random)

I have a list of names separated by a semi colon ;

Kristina H. Chung; Angela C. McMahon; Stephen I. Wilkinson; Bill L. Klein;
Paige H. Chen; Lawrence I. Miles; Samuel C. McCormick; Eileen O. Goldberg;
Sherri E. Melton; Glen R. Kramer; Willie E. Kent; Randall I. Hinson;
Gretchen I. Hill; Valerie E. Jennings; Kristina M. Small; Kelly E. Weiss;
Karen U. Puckett; Meredith O. Bowles; Debbie U. Bush; Elaine R. Pritchard;

I need a macro that will use this list to create a list which shows single names in each cell (without the semi colon character)

Any ideas?

Many thanks