| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data in columns
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data in columns
On Nov 22, 10:29*am, gary 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking data in 2 columns against a further 2 columns.... | Excel Worksheet Functions | |||
| Sorting Data into columns without replacing the columns with data | New Users to Excel | |||
| Help in code Steve G wrote to move data from 4 columns to 21 columns | Excel Programming | |||
| Arrange data spanning 8 columns and 3 rows to 24 columns and 1 row | Excel Discussion (Misc queries) | |||
| Transposing three columns into one row after manipulating data in columns | Excel Discussion (Misc queries) | |||
Linear Mode
