G gsxith3 May 25, 2007 #1 I want to delete all cells that contain specific text. Any help would be appreciated!
D Dave Peterson May 25, 2007 #2 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.
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.
G Gord Dibben May 25, 2007 #3 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
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
G Guest May 25, 2007 #4 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
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
