Excel - Sorting Data Help.

  • Thread starter Thread starter Mathiau
  • Start date Start date
M

Mathiau

Hey all!


k, a quick question.

i have one column - it is email address - i need to pull from this list all
email address that are @aol.com and @yahoo.com and put them into their own
list - how can i go about doing this?

Mathiau.
 
I think you may use Find() function to find out the position of "@" first,
then use Mid() function to get the following text, then put it to a new
column.

HTH
 
One more method:

Apply Data|Filter|Autofilter to that column.

Then use the dropdown and show Custom.
Then Contains @aol.com or contains @yahoo.com
(are you shooting for one list or two separate lists?)

Either way, just show the stuff you want and then copy|paste to a new location.

You can delete these rows, too if you want.
 
Back
Top