Replacing several rows

[Guest]

Hi all...
I have a form that I imported into Excel. There are rows that are repeated
throughout the worksheet that I want to delete (think of them as headers or
footers). I believe the text in each row I want to delete is the same, and
they are a continuous block (for example, rows 5-10, 21-26, 36-41, etc).
How can I select the text and tell Excel to delete all rows with that text?
thanks for any help you can throw my way.
john

 

[Damon Longworth]

In most cases you can sort the data and the header/footer rows will be
grouped together for easy deleting.

If not you may be able to create a formula to tag the target rows. Something
similar to:

=if(left(a1,5)=" ",na(),1)

Now you can use Edit - Go to - Special - Formulas - Errors. All target rows
will be selected and you can delete all at once.

--
Damon Longworth

2006 East Coast Excel User Conference
April 19/21st, 2006
Holiday Inn, Boardwalk
Atlantic City, New Jersey
Early Bird Registration Now Open!!
www.ExcelUserConference.com

2006 UK Excel User Conference
Summer, 2006
London, England
Hi all...
I have a form that I imported into Excel. There are rows that are repeated
throughout the worksheet that I want to delete (think of them as headers or
footers). I believe the text in each row I want to delete is the same, and
they are a continuous block (for example, rows 5-10, 21-26, 36-41, etc).
How can I select the text and tell Excel to delete all rows with that text?
thanks for any help you can throw my way.
john