Replacing multiple words from excel

[Stclements]

I have a list of some 20000 email addresses of which there are multiple words like, info,advice,service,web, etc,etc.
Is there away in Excel that I can somehow remove those addresses with those words in all at once rather than using the Replace function which only allows you to replace one word at a time.

 

[hiker95]

Stclements,

1. What version of Excel, and, Windows are you using?

2. Are you using a PC or a Mac?

3. What is the worksheet name where the raw data is?

4. What column?

5. What is the first cell in the column to contain the email addresses?

6. Can we see the complete list of multiple words like, info,advice,service,web, etc,etc.?

7. Can we see some examples of the e-mail addresses?


To start off, and, so that we can get it right on the first try:

Can you post a screenshot of the actual raw data worksheet?

And, can you post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post a small screen shot (NOT a graphic, or, picture, or, flat text) try one of the following:

MrExcel HTML Maker
If you do not know how to install and how to use HTML Mr.Excel Maker
https://www.youtube.com/watch?v=JycvgGppxt0&feature=youtu.be

Excel Jeanie
Download

Borders-Copy-Paste
http://www.mrexcel.com/forum/about-board/444901-how-create-table-like-aladin.html#post2198045

To test the above:
Test Here


Or, you can upload your workbook to (the BLUE link-->) Box Net ,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.

 

[RudiS]

If its a list of addresses, just use the filtering feature of Excel.
Once filtered, you can select the resulting records and delete them in one go!

 

[Stclements]

Thank you for your guidance unfortuanately I cannot provide you with the worksheet or a link to it as the information is of a delicate nature.

 

[hiker95]

Stclements,

Thank you for your guidance unfortuanately I cannot provide you with the worksheet or a link to it as the information is of a delicate nature.

sensitive data changed


Please answer all of the following questions.

1. What version of Excel, and, Windows are you using?

2. Are you using a PC or a Mac?

3. What is the worksheet name where the raw data is?

4. What column?

5. What is the first cell in the column to contain the email addresses?

6. Can we see the complete list of multiplewords like, info,advice,service,web, etc,etc. ?

7. Can we see some examples of the e-mail addresses?


You can upload your workbook to (the BLUE link-->) Box Net ,

sensitive data changed

mark the workbook for sharing

and provide us with a link to your workbook.


If you can not supply the above, then:

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[Stclements]

bump

 

[RudiS]

You never commented on the option of filtering those emails for the records to delete, as I commented above. Why would this NOT work? Filtering can very quickly remove the unneeded email addresses. If you use the search feature in the autofilter dropdown it will do a wildcard search for the word you type and adding the filter to the next filter allows one to quickly generate the list of unneeded emails, to which you can simple delete the filtered records in one go.

If the word list that determines the filter is larger than several words, a macro can assist to eliminate these emails fairly quickly.

 

[Stclements]

I havent had a chance to try it as yet but will do later. Many thanks for the guidance.

 

[hiker95]

Stclements, Rudis,

When you respond to a specific person, please use their site ID/username/handle.

This will keep thread clutter to a minimum, and, make the discussion easier to follow.

 

[RudiS]

Hiker95,

Can do
Cheers