software

I have a software which is very old (Open VMS, Unix Based). I have to do a
lot of formatting after downloading files from this software to Excel. Is
there a way or a software that i can use to download (Fixed Width Ascii
files) from my software to excel so that i don't have to do any formatting
after downloading???Thankx!


If your file is actually a fixed width file - and one record fitting on
one line.
Then copy and past the file into excel - it should all paste into
column A and then use as many rows as required.
Then in excel goto quot;DATAquot; then Select quot;TEXT TO COLUMNSquot; and follow the
directions.
Also you might ask your VM programmer to have the fields quot;commaquot; or
quot;semi-colonquot;, etc. deliminated and then you can still use the above
procedure.--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
View this thread: www.excelforum.com/showthread...hreadid=497126