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?