Relay-Version: version B 2.10 5/3/83; site utzoo.UUCP Path: utzoo!linus!philabs!cmcl2!harvard!husc6!panda!genrad!decvax!ittatc!dcdwest!sdcsvax!noscvax!tetra!jtjones From: jtjones@tetra.UUCP (Jeffrey T. Jones) Newsgroups: net.micro.pc Subject: Re: LOTUS QUESTION Message-ID: <141@tetra.UUCP> Date: Mon, 5-May-86 11:22:29 EDT Article-I.D.: tetra.141 Posted: Mon May 5 11:22:29 1986 Date-Received: Thu, 8-May-86 08:26:54 EDT References: <3474@gatech.CSNET> Reply-To: jtjones@tetra.UUCP (Jeffrey T. Jones) Organization: Naval Ocean Systems Center, San Diego Lines: 17 In article <3474@gatech.CSNET> andrew@gatech.CSNET (Andrew Ditchfield) writes: >I am importing an ASCII file that is in a table format. The problem is that >the whole table is assigned to column 'A' of the spreadsheet. After several >records a table record is encountered which is too big to read into one >column of Lotus. >Any advice on how to map the fields in my table like ASCII file to the >columns in Lotus ?? Try using the /FIN (file - import - numbers) instead of /FIT (text). I use this all the time and it works Ok. The only thing that bugs me is that I lose all the text. However, the numbers are what's important to me, and they work fine. Hope this helps... -- Any opinions expressed are my own, and have NO connection with my employer. -- Jeffrey T. Jones jtjones@nosc.ARPA (619) 225-7815 {ihnp4,decvax,ucbvax}!sdcsvax!noscvax!jtjones