Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
import formatted text
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
import formatted text
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)? "dap_125" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
import formatted text
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... ----------------------------------------------------------------------- "dap_125" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
import formatted text
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. dap_125 wrote: 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. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
import formatted text
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 "dap_125" wrote: 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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
import formatted text
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 "dap_125" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use formatted text instead of number value... | New Users to Excel | |||
Can a Text Box be Formatted in Columns? | Excel Discussion (Misc queries) | |||
Dates formatted as text | Excel Discussion (Misc queries) | |||
Text formatted as All Capitals? | New Users to Excel | |||
Converting 'General' formatted cells to Text formatted cell using. | Excel Worksheet Functions |