Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting email address from various data
Example of data:
H: (111) 222-3333 W: (111) 222-3333 Cel: (111) 222-3333 W Fax: (111) 222-3333 Email: ----------------------------------------------------------------------------------- H: (444) 555-6666 W: (444) 555-6666 Email: W Fax: (444) 555-6666 Example = 1 column and 2 rows of data and I am trying to extract the email address and place it into a single column without cut and paste 5000 times. The text to columns feature works but spread the addresses haphazardly across 20+ columns. That leads to a new question, I want the email in column A and they are spread out B-Z. How do I get them all in column A without C&P. I tried "=B1-Z1" in A1 and got "#VALUE". |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting email address from various data
If you had your data in column B, type this in A1:
=RIGHT(B1,LEN(B1)-FIND("Email: ",B1)-6) and copy it down "Wade" wrote: Example of data: H: (111) 222-3333 W: (111) 222-3333 Cel: (111) 222-3333 W Fax: (111) 222-3333 Email: ----------------------------------------------------------------------------------- H: (444) 555-6666 W: (444) 555-6666 Email: W Fax: (444) 555-6666 Example = 1 column and 2 rows of data and I am trying to extract the email address and place it into a single column without cut and paste 5000 times. The text to columns feature works but spread the addresses haphazardly across 20+ columns. That leads to a new question, I want the email in column A and they are spread out B-Z. How do I get them all in column A without C&P. I tried "=B1-Z1" in A1 and got "#VALUE". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to validate email address during data entry in Excel | Excel Discussion (Misc queries) | |||
Extracting data for address lists | Excel Worksheet Functions | |||
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) | |||
How do I include cell data in subject line of email address/hyperl | Excel Worksheet Functions |