View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
wjohnson
 
Posts: n/a
Default Advanced export/ Fixed length fields


Go to FILE - SAVE AS - and then in the SAVE AS TYPE - Scroll down until
you find "Formatted Text (Space Delimited *.prn), this should work for
you. If you cannot find it then you might need to reinstall "ALL" of
the EXCEL conversion that are available. If you do the normal install
of OFFICE - sometimes you do not get ALL of the conversion features
added to the your programs. Then you can rename the *.prn to *.txt and
import into your other program. Just be sure to use a COURIER font to
view it, otherwise - text may not look like it lines up.


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