Hi Guys,
I am trying to clean up an excel spreadsheet. It has 4500+ entries. Important columns are:
Company Name
Contact Name
Email Address
It has mixed email addresses i.e info@ sales@ admin@ marketing@ support@ and Personanme@example.com
I want to clean the whole sheet for these generic email addresses and keep them only with person name email addresses.
I have managed to apply simple filters and removed generic emails "info@ sales@ admin@ marketing@ support@" but there are many other custom email addresses that needs to be moved to another. they are all different but generic so need to move these to another sheet where i already put these generic records. I want to move full row not only a cell "email". Some of the bad records are:
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]23[/TD]
[TD="align: right"]63801[/TD]
[TD="align: center"]24[/TD]
[TD="align: right"]28027[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"]26[/TD]
[TD="align: right"]33634[/TD]
</tbody>
In Simple - I want to filter by email address and Contact name matching. I.e
If Contact name is John Smith and Email include his name or starting with Smith or has smith in the email I would like to filter it. At the moment there are about 2900 records in total which i need filter applied. I have already filtered the most generic email addresses.
Good records example:
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: right"]85013[/TD]
[TD="align: center"]5[/TD]
[TD="align: right"]32724[/TD]
[TD="align: center"]6[/TD]
[TD="align: right"]78732[/TD]
</tbody>
Thanks in advance
I am trying to clean up an excel spreadsheet. It has 4500+ entries. Important columns are:
Company Name
Contact Name
Email Address
It has mixed email addresses i.e info@ sales@ admin@ marketing@ support@ and Personanme@example.com
I want to clean the whole sheet for these generic email addresses and keep them only with person name email addresses.
I have managed to apply simple filters and removed generic emails "info@ sales@ admin@ marketing@ support@" but there are many other custom email addresses that needs to be moved to another. they are all different but generic so need to move these to another sheet where i already put these generic records. I want to move full row not only a cell "email". Some of the bad records are:
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 3rd Strike Performance | 409 County Hwy 448 | Sikeston | MO | Duane Garrett | Owner | 3rdstrike@charter.net | ||
| 3SX Performance Automotive Inc. | 4494 Raceway Dr. | Concord | NC | Stephen Burrows | President | onlinestuff@3sxperformance.com | ||
| 4 Wheel Center Inc. | 7210 Gateway Blvd. E | El Paso | TX | 79915-1301 | Carlos Enriquez | President | wfour@elp.rr.com | |
| 4 Wheel Online | 5911 Benjamin Center Dr. | Tampa, | FL | Ryan Heath | President | managment@4wheelonline.com |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]23[/TD]
[TD="align: right"]63801[/TD]
[TD="align: center"]24[/TD]
[TD="align: right"]28027[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"]26[/TD]
[TD="align: right"]33634[/TD]
</tbody>
In Simple - I want to filter by email address and Contact name matching. I.e
If Contact name is John Smith and Email include his name or starting with Smith or has smith in the email I would like to filter it. At the moment there are about 2900 records in total which i need filter applied. I have already filtered the most generic email addresses.
Good records example:
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1474773 AB Inc. | 5414 Rue Eaglemont | Beaumont | AB /CA | T4X 0H2 | Dave Hubert | Owner | D.hubert@gmx.com | |
| 180 Degrees Automotive | 545 W Mariposa St. | Phoenix | AZ | Bogi Lateiner | President, Master Mechanic, Educator | Bogi@180auto.com | ||
| 1932 Deuce Coupe LLC | 1200 Orange Camp Rd. | Deland | FL | Robert Fortner | President | hotrod.robert@hotmail.com | ||
| 1ShopAuto | 1100 Merlene Dr. | Austin, | TX | Alan Brown | CEO | Alan@1ShopAuto.com |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: right"]85013[/TD]
[TD="align: center"]5[/TD]
[TD="align: right"]32724[/TD]
[TD="align: center"]6[/TD]
[TD="align: right"]78732[/TD]
</tbody>
Thanks in advance
Last edited:
