>Hi,
>
>I am using excel to view a fixed width text file by using excel's Text Import Wizard. It work's fine. My problem is everytime I get new text file in same format I have to set my field width (column breaks) by clicking the mouse on the defined column positions. Is there any way thru which I can set the format (since it is always the same) and load the text file into excel ?
>
>
>
>Thanks in Advance
>
>Regards
>Ashish Patel
One way would be to write a program in some programming language, to convert your file into some other format, for instance, comma-delimited. Probably this could be done in Excel itself, but it might be a little complicated.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)