Break out information from cell

[normpam]

I have copied from an email a very long list of emails but they all end up in one single cell

sample: eyee@gruposhahani.com; laroyeimport@gmail.com; sjimenez@vsjimenez.com; yhwh_shekhinah@hotmail.com; sparcells@formatec.com.pa

and would like to know if there is a way I can quickly create a list separating each email into a different cell. I was thinking of using a MID formula or maybe an INDEX or MATCH, but cannot figure out how to make it work.

Thanks!

 

[Jonmo1]

Try Data - Text to columns - Deliminated - SemiColon

 

[normpam]

Try Data - Text to columns - Deliminated - SemiColon

Thanks. That was pretty stupid of me! I didn't even try text to columns... I thought it would only work on multiple cells, not with a delimiter within a cell!

Works like a charm.

 

[Jonmo1]

Glad to help, thanks for the feedback.
You might also check "Space" as a deliminator as well as semicolon.