Replacing multiple words from excel

Stclements

Board Regular
Joined
Aug 6, 2008
Messages
236
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.
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
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.
 
Last edited:
Upvote 0
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!
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,561
Messages
6,114,316
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top