Conditional Delete

[gsxith3]

I want to delete all cells that contain specific text. Any help would
be appreciated!

 

[Dave Peterson]

I'd select that column and do
Data|Filter|autofilter
Then use the dropdown and choose custom
contains: (type in your value)

And delete the visible rows

Then data|Filter|autofilter (to remove the filter)

=======
You may be able to chose the value you want from the dropdown, too--avoiding the
Custom stuff.

 

[Gord Dibben]

Edit>Find

what: yourtext

Find all.

In the found dialog box select first found cell then hold SHIFT key and select
last found cell in the dialog box.

Edit>Clear>Contents or Delete>Shift cells left or up.


Gord Dibben MS Excel MVP

 

[Barb Reinhardt]

Delete or clear?

How about Searching for that value and finding all entries and then
selecting all of them. You can clear from there.

HTH,
Barb Renhardt