LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
wjohnson
 
Posts: n/a
Default Software to download Fixed Width Files


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 "DATA" then Select "TEXT TO COLUMNS" and follow the
directions.
Also you might ask your VM programmer to have the fields "comma" or
"semi-colon", etc. deliminated and then you can still use the above
procedure.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=497126

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can excel files be opened in fixed screen size preset by user? vabraham Excel Discussion (Misc queries) 1 August 28th 05 03:08 PM
Producing fix width text files Chris Excel Discussion (Misc queries) 3 May 26th 05 04:29 AM
Is there anyway that I can download free MS-office software from Shirley Excel Discussion (Misc queries) 2 May 9th 05 11:27 PM
Export to fixed width text file FinChase Excel Discussion (Misc queries) 0 January 24th 05 07:25 PM
Free Download of File Conversion Software Boba Fett Excel Discussion (Misc queries) 0 December 4th 04 07:49 PM


All times are GMT +1. The time now is 11:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"