| 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: ? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
find email address in a cell
On Tue, 24 Jul 2007 09:00:04 -0700, Frederique
wrote: From: Mail Delivery Subsystem IF the email address is the only content that is enclosed in angles (<...) then this should work: =MID(A1,FIND("<",A1)+1,FIND("",A1)-FIND("<",A1)-1) --ron |
| Reply |
| 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) | |||
Hybrid Mode
