Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I CREATE TWO COLUMN WIDTHS IN ONE COLUMN DIFFERENT ROW IN E | New Users to Excel | |||
how do I update a column and create new rows for new column cells | Excel Discussion (Misc queries) | |||
how do I create multiple column width in the same column in excel | Excel Discussion (Misc queries) | |||
finding 600 emails in a column | New Users to Excel | |||
How do I create column headings in Excel in the A, B, C etc column | Excel Discussion (Misc queries) |