Data in columns

  • Thread starter Thread starter gary
  • Start date Start date
G

gary

In my Excel spreadsheet:

col A contains last names
col B contains first names
col C contains middle initials
col D contains suffixes (for example, JR, SR, III, etc).

When I save the spreadsheet as a TEXT file and open that file in a
text-editor, the columnar-formatting is lost (i.e., the last names,
first names, middle initials and suffixes are no longer in columns).

How can I save the spreadsheet as a TEXT file and keep the columnar-
formatting?
 
In my Excel spreadsheet:

col A contains last names
col B contains first names
col C contains middle initials
col D contains suffixes (for example, JR, SR, III, etc).

When I save the spreadsheet as a TEXT file and open that file in a
text-editor, the columnar-formatting is lost (i.e., the last names,
first names, middle initials and suffixes are no longer in columns).

How can I save the spreadsheet as a TEXT file and keep the columnar-
formatting?
Click to expand...

Try saving as .CSV and you will see with commas between.
 
Back
Top