Excel - Sorting Data Help.

[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.

 

[Harry]

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

 

[Dave Peterson]

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.