PDA

View Full Version : Formatting A Sheet With Fixed Width For Importing HTML File



justme1052
02-01-2014, 11:26 PM
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.

Excel Fox
02-03-2014, 06:17 PM
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.