Excel Find and Delete

[brogan]

Hi,

I have an Excel spreadsheet (which is a mailing list) and I need to delete a number of common keywords.

Manually deleting takes forever and using Find and Replace with a blank works but when you shut down Excel and open it again it doesn't remember the keywords (around 50 of them) I want to delete.

Any ideas guys how I can speed up this process?

Many thanks if so!

Kind regards

Mark

 

[xlbo]

To speed this up you would require VBA.

The basic premis wopuld be to hold a list of key words and then use FIND / Replace in code to loop through that list, applying to your mailing list

If you wish to proceed with this, please post in teh VBA Forum: Forum707

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Welshbird]

Could you have your list in another sheet and use vlookup?

Fee

The question should be [red]Is it worth trying to do?[/red] not [blue] Can it be done?[/blue]

 

[xlbo]

Fee - Depends whether the keywords are in a cell by themsleves or contained as part of a longer word structure. If there is more than 1 word per cell then no, vlookup couldn;t be used...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question