Data in columns

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?
 
D

Don Guillett

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?

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top