delete multiple rows

[eugz]

Hi All.

In worksheet I would like to delete all rows where value of first cell of row not DATE. How it to do?

Thanks.

[TMS]

Easiest way would be to switch on Autofilter, filter on the column for not DATE, select the visible rows and delete them.


Regards, TMS

[eugz]

Hi TMS. Thanks for replay.

Your advice may be will good in other case. In my case some records occupy more than 2 rows. For example:

07/30/2014	1244	1	Order	success	NNN-OOO-IP *Pt Area	80 mg tab by mouth q bedtime Daily
					Default* (GUI w/CML)	Patient is not responding to
						Formulary agent. 2784
						Non-formualary form sent to Dr.
						ZZZZZ for approval

Actually I try to convert report text file to Excel. May be that will help to give me better suggestion?

Thanks.

[sakmsb]

Hi TMS. Thanks for replay.

Your advice may be will good in other case. In my case some records occupy more than 2 rows. For example:

07/30/2014 1244 1 Order success AAA-BBB-IP *Pt Area 80 mg tab by mouth q bedtime Daily
Default* (GUI w/CML) Patient is not responding to
Formulary agent. 9999
Non-formualary form sent to Dr.
ZZZZZZ for approval

Actually I try to convert report text file to Excel. May be that will help to give me better suggestion?

Thanks.

Hi,

Plz attach a sample file if feasible, it will help other help you better.

~