How to find and replace with blanks or actually delete row
 

I have a report I run that identifies lots of rows with column A having the
word filtered, and column b having garbage. I've tried a find and replace by
hitting space bar 8 times (filtered has 8 characters) and replace filtered
with a blank cell. Column B still has garbage. How can I delete any "row"
that says filtered and have the rows compress to get rid of the large void?
I'm talking about 33,000 rows being gone at one time instead of blocking and
deleting, blocking and deleting, etc.... Can anyone help with instructions
on how to delete the numerous rows of garbage in an Excel document with one
key stroke?
--
Patmarie985

How to find and replace with blanks or actually delete row
 

Hi,

After filitering on column A. Select the visible cells in column B and press
Del.

--
Thanks,
Shane Devenshire


"Patmarie985" wrote:

I have a report I run that identifies lots of rows with column A having the
word filtered, and column b having garbage. I've tried a find and replace by
hitting space bar 8 times (filtered has 8 characters) and replace filtered
with a blank cell. Column B still has garbage. How can I delete any "row"
that says filtered and have the rows compress to get rid of the large void?
I'm talking about 33,000 rows being gone at one time instead of blocking and
deleting, blocking and deleting, etc.... Can anyone help with instructions
on how to delete the numerous rows of garbage in an Excel document with one
key stroke?
--
Patmarie985