Column has emails & other stuff. Want to create a column w/ just e
 

Hi again,

Thank you for all the help I have received so far in this site, it's great.
Here is the question: I want to take a column that has a list of emails and
other stuff I don't want. Can I create a new column that has only those cells
in the original column with emails? I just want a column with just the
emails, one below the other with no gaps. I guess searching for words with
the symbol "@" would be an strategy, but how can I do it and using which
formulas?

Thank you once again!

Jorge

Column has emails & other stuff. Want to create a column w/ just e
 

Data Filter Autofilter choose the arrow at the top of your column, then
Custom Contains @

Vaya con Dios,
Chuck, CABGx3



"Jorge" wrote:

Hi again,

Thank you for all the help I have received so far in this site, it's great.
Here is the question: I want to take a column that has a list of emails and
other stuff I don't want. Can I create a new column that has only those cells
in the original column with emails? I just want a column with just the
emails, one below the other with no gaps. I guess searching for words with
the symbol "@" would be an strategy, but how can I do it and using which
formulas?

Thank you once again!

Jorge