| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find email address in a cell
I have a file with 65000 rows of data (extracted from email inbox)
I applied a formula to identify which rows had an address =IF(COUNTIF(A1,"*@*"),"","email") then a second one to remove the email with our company name I am left with less than 200 rows Example: "From: Mail Delivery Subsystem " What formula can I apply to get: ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter an email address w/in a cell & it not be automatic | Excel Discussion (Misc queries) | |||
| can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
| Transfer Email addresses from spreadsheet to email address book | Excel Discussion (Misc queries) | |||
| Can you enter @ symbol without becomig email address in a cell? | Excel Discussion (Misc queries) | |||
| How to format a cell as email address | Excel Discussion (Misc queries) | |||
Threaded Mode
