import formatted text

[Guest]

I have a formatted text report with headers that I need to import into Excel.
Is there an easy way to remove the headers so that I don't have to manually
delete them all? Or import the data without the headers, or just format the
headers.
The report has over 1000 pages.

 

[Guest]

A little more info about the import results and we may be able to help better.

Do these 1000+ pages come into a single Excel sheet or are they split across
multiple sheets (if so, how many? 10? 1000+)?

Is it safe to assume that what you're getting are the headers showing up in
the middle of the sheet of data at the beginning of each new 'page' of data
like:
HEADER
data
data
data
HEADER
data
data
data

If so, is there a pattern (header appears first at row X and then again
every Y number of rows after that)? Or perhaps the text in the header is
unique and identifiable (if so, what is the text)?

 

[Earl Kiosterud]

Dap,

No tool in Excel to remove page headings. I've had to do that with a macro. I did one
recently that you could use, with modification to your print layout. It uses a text import
to bring the data in from the text file, then strips all but the actual records (headings,
sub-headings). My email address is at my site, below. I'll send it to you if you want to
start with it.

--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...

 

[Dave Peterson]

Maybe you could apply data|Filter|autofilter to that column with the header.

Then filter to show only those header rows
and delete the visible rows
and remove the filter.

 

[Guest]

Hi,

If you want to import a Worsksheet from any of your workbook in to a
worksheet in a differnt workbook, then do this as follows:

1. Click a cell location in your worksheet.
2. On the Data menu, point to Import External Data, and then click Import
Data to diaplay the Select Data Source dialog box.
3. In the Look in list the select the Microsoft Excel file you want to
Import. The Select Table dialog box displays with all the worksheets.
4. Click the select the worksheet Name.
5. Clear the "First row of data contains column header" check box.
6. Click Ok. This displays the Import Data dialog prompting you whether you
want the data to be imported in the current cell location or in a new
worksheet?
7. Select the current cell location under the Exiting worksheet list.
8. Click Properties to display the "External Data Range Properties" dialog
box.
9. Under the Data Formatiing and Layout, clear the "include field name"
check box.
10. Click OK. This closes Data Formatiing and Layout and return to Import
Data dialog box.
11. Click OK to return to the worksheet, to view the imported data in the
cell location.

Challa Prabhu

 

[Guest]

Hi,

If you want to import a Worsksheet from any of your workbook in to a
worksheet in a differnt workbook, then do this as follows:

1. Click a cell location in your worksheet.
2. On the Data menu, point to Import External Data, and then click Import
Data to diaplay the Select Data Source dialog box.
3. In the Look in list the select the Microsoft Excel file you want to
Import. The Select Table dialog box displays with all the worksheets.
4. Click the select the worksheet Name.
5. Clear the "First row of data contains column header" check box.
6. Click Ok. This displays the Import Data dialog prompting you whether you
want the data to be imported in the current cell location or in a new
worksheet?
7. Select the current cell location under the Exiting worksheet list.
8. Click Properties to display the "External Data Range Properties" dialog
box.
9. Under the Data Formatiing and Layout, clear the "include field name"
check box.
10. Click OK. This closes Data Formatiing and Layout and return to Import
Data dialog box.
11. Click OK to return to the worksheet, to view the imported data in the
cell location.

Challa Prabhu