select the column, then choose DataText to Columns... from the menu

Select delimited, and check the tab box. You can also specify whether to
ignore some columns & otherwise customize the conversion of the data

If you want to accomplish this on opening the file, be sure the file has a
txt extension, and Excel should bring the Import wizard dialog box up before
importing the file


"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