Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to sort and export just email addresses in a mixed column
I have a column that has a mixture of email addresses and other stuff in it.
I want to sort it to show just the email addresses and then export them. How can I do that? Thx. Scott |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to sort and export just email addresses in a mixed column
How about an alternative?
Instead of sorting, you can use an Autofilter. Select the column Data|Filter|Autofilter (in xl2003 menus) Use a custom filter Contains: @ And then copy the visible rows and paste where you want. (and remove the filter. If all the rows (visible and hidden) get pasted, then add another step after applying the custom filter (contains @). Select the range to copy F5 (edit|goto)|Special|visible cells only Then do the Copy|paste. scotika wrote: I have a column that has a mixture of email addresses and other stuff in it. I want to sort it to show just the email addresses and then export them. How can I do that? Thx. Scott -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort a column of email addresses by end portion of address | Excel Discussion (Misc queries) | |||
can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
How do I export email addresses from Excel to Outlook? | Excel Discussion (Misc queries) | |||
How do I export email addresses from excel to outlook? | Excel Discussion (Misc queries) | |||
How do you sort a column of email addresses by domain name in Exc. | Excel Discussion (Misc queries) |