separate list of names in same cell separated by semicolon into one single list

[maacmaac]

I have list of names in one single cell and are separated by a semicolon.

For example, in cell A1 I have:
Smith, Todd; Mike Anderson; Simon Jr., Pete; Smith, Sue

I would like to list the names in multiples cells in a vertical column. Desired result is:

Smith, Todd
Mike Anderson
Simon Jr., Pete
Smith, Sue

Thanks

[nilem]

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.