Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replace blanks using formula | Excel Worksheet Functions | |||
How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
Need to get rid of 0's and replace with Blanks | Excel Worksheet Functions | |||
How can I use find and replace to delete a word in Excel? | Excel Discussion (Misc queries) | |||
replace "#DIV/0!" error with blanks | Excel Worksheet Functions |