spearate names from list

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

Thanks 'Thisisgerald'

It is nearly there, I just need it to place them in the same collumn now instead of splitting htem across multiple columns.

Is this possible?

Many thanks

Bravo Mike!

Worked perfectly!

did exactly as i wanted!

Thank you soooo much!

F