Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,344
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
replace blanks using formula susiecc60 Excel Worksheet Functions 1 March 27th 06 02:16 AM
How to Delete a Range in Closed Workbook (to Replace Delete Query) [email protected] Excel Discussion (Misc queries) 1 March 8th 06 11:10 AM
Need to get rid of 0's and replace with Blanks Intuit Excel Worksheet Functions 3 February 3rd 06 09:55 PM
How can I use find and replace to delete a word in Excel? callpaultwt Excel Discussion (Misc queries) 2 December 1st 05 10:11 PM
replace "#DIV/0!" error with blanks Mark B Excel Worksheet Functions 0 June 22nd 05 10:19 AM


All times are GMT +1. The time now is 02:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"