Replacing several rows
 

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

Replacing several rows
 

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
"JohnnyJomp" wrote in message
...
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