How do I get each address numbered instead of being as a group?

Hello, I am copying email addresses into Excel and they entered as a group instead of numbering each line. How do I get each address numbered instead of being as a group?

Welcome to teh forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

Thanks.

Post an example workbook, and explain in context.