Jim
When you open the *.txt file in Excel using FileOpen, the Text Import Wizard
should open giving you a choice of delimiters.
If the Wizard doesn't open, go to DataText to Columns and select Tab
delimited.
Follow the wizard through to "Finish" and you data will go into columns.
Gord Dibben Excel MVP
On Tue, 3 May 2005 08:53:05 -0700, jim wrote:
I want the individual tab delimited fields to be represented in Excel as rows
of their own. Right now the entire tab delimited file is in the first column.
Thanks
|