Email (LDAP) data download into a single Excel cell - data separat

[MSA]

I hope someone could guide me. I have downloaded email names from outlook and
imported in Excel. unfortunately all the names are pasted in a single cell
e.g.

smith, john(dept A); kohl, nancy(dept B);................,turner, ted(dept X);

What I would like to do is somehow separate each name into a single cell
separately based on ";" where this character occurs.

Thanks in advance!

 

[Dave Peterson]

Check your other post.

I hope someone could guide me. I have downloaded email names from outlook and
imported in Excel. unfortunately all the names are pasted in a single cell
e.g.

smith, john(dept A); kohl, nancy(dept B);................,turner, ted(dept X);

What I would like to do is somehow separate each name into a single cell
separately based on ";" where this character occurs.

Thanks in advance!