Transpose issue

[Burger23]

I have a series of email addresses from an Outlook email. I want to use
Excel's sort feature to sort these email addreeses looking for duplicates.

I have attempted to copy , paste special, and transpose to insert this
semi-colon separated row into an Excel column. It does not work (inserts as a
row)

Ideas?

 

[Joel]

I just did it. Follow these steps

1) Copy email addresses from an e-mail
2) Paste in a single cell into excel
3) Highlight cell and use in excel menu Data - text to columns
4) Select delimited. Use only semicolon
5) Copy cells in row and Paste special with transpose.
6) You now have email names with commas (seperating first and last names)
and dashes (Optional if multiple company sites). Highlight all email
addresses in one column. Again use text to columns. This time use delimited
with commas and dashes as seperators.

You will now have names wirth first and last names in different columns.