How to find and replace with blanks or actually delete row

P

Patmarie985

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?
 
S

ShaneDevenshire

Hi,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Eliminate blanks while copy row and transpose 11
Find and Delete Row 1
Find and Replace one row only 2
Find and Replace 6
Insert blanks, but populate new blank rows in one column 6
Macro Pause to Select range then Subtotal 0
How do I find & replace pieces of a formula? 5

Top