Results 1 to 2 of 2

Thread: Formatting A Sheet With Fixed Width For Importing HTML File

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Dec 2013
    Posts
    7
    Rep Power
    0

    Formatting A Sheet With Fixed Width For Importing HTML File

    I download a HTML data file daily. I used the fix width setting on the first file so I could separate the info to go to each cell how I wanted them to go. this worked great the first 4 or 5 days. Now when I download the HTML file some info will go to the right cells and some will be off by 1 or 2 cells up or down.
    Is there a special setting, formula, code or anything to use to make sure the the downloaded data info goes to same cells, as when first setup using the fix width setting.

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    It would help if you can post samples of the downloaded html file, clearly describing what you intended to do, and what's the problem that you want solved.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Replies: 16
    Last Post: 12-23-2013, 03:44 PM
  2. HELP Import data from attached HTML file to excel
    By amar.kshirsagar in forum Excel Help
    Replies: 6
    Last Post: 09-30-2013, 03:05 PM
  3. Print excel sheet to a PDF file
    By xander1981 in forum Excel Help
    Replies: 2
    Last Post: 12-14-2012, 02:16 PM
  4. Importing a csv File to a range
    By SDruley in forum Excel Help
    Replies: 21
    Last Post: 11-20-2012, 04:54 PM
  5. Replies: 2
    Last Post: 04-08-2012, 09:42 AM

Posting Permissions

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