Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose issue
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose issue
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. "Burger23" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transpose? | Excel Worksheet Functions | |||
I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES | Excel Worksheet Functions | |||
Please Help with TRANSPOSE | Excel Worksheet Functions | |||
Transpose | Excel Worksheet Functions | |||
TRANSPOSE() | Excel Worksheet Functions |