full of problems!!!
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: full of problems!!!

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Illinois
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I know I am asking bunches of questions but here goes another one..........

    I imported a large text document into excel, all of the pages have a header on them (like 800 pages). How do I remove all of the headers in one easy task? Basically I have multiple rows at the top of each page to delete.

    Thanks
    Ed.


    [ This Message was edited by: edsjr on 2002-03-28 18:28 ]

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Ed

    RE: I know I am asking bunches of questions but here goes another one..........

    That's the idea, don't feel guilty!

    The very first step of the Import Text Wizard allows you to specify whic Row to start at, just change this to suit.



  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Illinois
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    i cant tell you how many times i have imported text files into excel and i have never even noticed that part of the box! will that get rid of the header on the first page or will it take care of all of the headers on all the pages?

    thanks
    Ed.

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Ontario, Canada
    Posts
    337
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-28 18:27, edsjr wrote:
    I know I am asking bunches of questions but here goes another one..........

    I imported a large text document into excel, all of the pages have a header on them (like 800 pages). How do I remove all of the headers in one easy task? Basically I have multiple rows at the top of each page to delete.

    Thanks
    Ed.


    [ This Message was edited by: edsjr on 2002-03-28 18:28 ]

    It would make your life much easier if you could obtain a "comma delimited" file, check with who ever provided the file.

    I was never able to solve this problem, I used to sort the data by a particular column that would pull all the header data together. then apply filters and select the data I wanted to remove. If you try recording a Macro you risk losing data, I used to record the import right up to the sort then I'd do the rest manually.

    But I'd be curious to know if some one has a solution.



  5. #5
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ziggy, can't you do as I suggested? I don't think it gets much easier than that.



  6. #6
    New Member
    Join Date
    Mar 2002
    Location
    Illinois
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I tried to do it by telling it to start at row #17 (first line of real data) and it only got rid of the header on the first page. I am providing this file myself, it is coming from my invoicing system.

    thanks
    Ed.

  7. #7
    Board Regular
    Join Date
    Feb 2002
    Location
    Ontario, Canada
    Posts
    337
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sorry, I got mixed up, my problem included detail headers, with varying lengths of detail. They're the ones I had difficulty removing.

  8. #8
    Board Regular eliW's Avatar
    Join Date
    Mar 2002
    Posts
    1,919
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-28 18:27, edsjr wrote:
    I know I am asking bunches of questions but here goes another one..........

    I imported a large text document into excel, all of the pages have a header on them (like 800 pages). How do I remove all of the headers in one easy task? Basically I have multiple rows at the top of each page to delete.

    Thanks
    Ed.


    [ This Message was edited by: edsjr on 2002-03-28 18:28 ]
    Ed.
    If the first cell in every row you want to preserve contains numeric data, then you can use a VB code to check the first cell in every row and delete the whole row if it is not numeric.
    This worked for me and deleted almost all the unwanted headers.
    Eli

    [ This Message was edited by: eliW on 2002-03-29 00:06 ]

  9. #9
    Board Regular
    Join Date
    Mar 2002
    Location
    Leiden, The Netherlands
    Posts
    68
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I recognize the problem. Usually, I solve it by using the autofilter command. This presupposes that the headers differ from the rest of your document. Filter the columns so that you only get to see the headers, select them all and delete them.

    Marc

  10. #10
    New Member
    Join Date
    Mar 2002
    Location
    Illinois
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I will try it tonight and see what I come up with. Is there a good place to learn how to use these functions? Trial and error has been my main way to learn how to use Excel, thank god for the "undo" button!

    Ed.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com