I'm afraid in this case you have to find a criterium to identify title rows
(e.g. they always begin with certain character(s) or contain certain string,
etc.) and this criterium certainly does not apply to your normal data rows.
Create a macro which recognizes and delete title rows, and place it in
Sub Workbook_Open()

Regards,
Stefi


€žMandeep Dhami€� ezt Ã*rta:

Thanks Stefi.
But this does not solve my query completely.
I think the suggestion given by you can only be done for verticle colomns
but in .txt file after a page breck (new page) all the headings (title rows)
are repeated so I want that the title rows should not be repeated after
exporting in excel.
The .txt document has some where around 100+ pages so the heading rows is
repeated 100+ times which i don't want.

Hope i am able to clear my doubt.......

Cheers,
Mandeep

"Stefi" wrote:

The simplest way is to record the process of opening a .txt file with the
wizard as a macro. You will have an option for each column to omit it.

Regards,
Stefi


€žMandeep Dhami€� ezt Ã*rta:

Hi,

I have various report extracted from different applications in .txt format.
I would like to transfer the same report from .txt format to excel.......the
report in .txt is generated on regular basis.
The report in .txt format contains many unwanted fileds. Can we write a
macro to export the data from .txt to excel so that the fileds required can
only be exported to excel.

Please help....

Cheers,
Mandeep