PC Review


Reply
Thread Tools Rate Thread

Data in columns

 
 
gary
Guest
Posts: n/a
 
      22nd Nov 2011
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?
 
Reply With Quote
 
 
 
 
Don Guillett
Guest
Posts: n/a
 
      22nd Nov 2011
On Nov 22, 10:29*am, gary <gcott...@hotmail.com> wrote:
> 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.

 
Reply With Quote
Reply

« Tech help | Thanks »
Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:18 AM.