Forum Discussion
Solved
Excel
I have a client list in excel that contains name, address, and phone. On some records, the email address is in the address. Across columns are various other items (invoice amounts, dates, etc.). I ne...
Hi
Address Line 1 Address Line 2 Address Line 3 Email Address Line 1 1200 SPUR ST #300 MARKET, MO 62206 1200 SPUR ST 4522 Main Dr Nowhere, TN 37544 4522 Main Dr MYEMAIL@YAHOO.COM MYEMAIL@YAHOO.COM youremail@gmail.com youremail@gmail.com 123 Any Street #401 Anytown, TX 11111 123 Any Street Talktome@rocket.net Talktome@rocket.net Columns F:J
Formula in I:
=IF(COUNTIFS(F2,"*@*"),F2,"")
Formula in J:
=SUBSTITUTE(F2,I2,"")
I provided an example. Is it not possible to do this?
Hi
| Address Line 1 | Address Line 2 | Address Line 3 | Address Line 1 | |
| 1200 SPUR ST | #300 | MARKET, MO 62206 | 1200 SPUR ST | |
| 4522 Main Dr | Nowhere, TN 37544 | 4522 Main Dr | ||
| MYEMAIL@YAHOO.COM | MYEMAIL@YAHOO.COM | |||
| youremail@gmail.com | youremail@gmail.com | |||
| 123 Any Street | #401 | Anytown, TX 11111 | 123 Any Street | |
| Talktome@rocket.net | Talktome@rocket.net |
Columns F:J
Formula in I:
=IF(COUNTIFS(F2,"*@*"),F2,"")
Formula in J:
=SUBSTITUTE(F2,I2,"")
- Excellent! Works like a charm. Thank you!