| 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". |
| 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 | |||
Threaded Mode
