View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jorge Jorge is offline
external usenet poster
 
Posts: 28
Default 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