| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Generate a TAB When Converting From Excel to Delimited Text
Is there a way to move data from Excel to a tab-delimited text file and have
Excel throw the tabs in? As an example I currently have 4 columns (one row) of data: Cell A1: ABCDEF Cell B1: 123 Cell C1: 00ZFR Cell D1: EEEE When save as txt, the first row reads ABCDEF12300ZFREEE with no delimiting tabs. I am having to manually enter the tabs to parse the string. Can this be done automatically? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Generate a TAB When Converting From Excel to Delimited Text
Very simple.
File/ Save As: Tab delimited text -- David Biddulph "ConfusedNHouston" wrote in message ... Is there a way to move data from Excel to a tab-delimited text file and have Excel throw the tabs in? As an example I currently have 4 columns (one row) of data: Cell A1: ABCDEF Cell B1: 123 Cell C1: 00ZFR Cell D1: EEEE When save as txt, the first row reads ABCDEF12300ZFREEE with no delimiting tabs. I am having to manually enter the tabs to parse the string. Can this be done automatically? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Excel file to text delimited file | Excel Discussion (Misc queries) | |||
| Converting excel file to tab delimited (txt) file | Excel Discussion (Misc queries) | |||
| Converting negative/positive numbers to a CSV (Comma-delimited .TX | Excel Worksheet Functions | |||
| Converting from CSV to Tab Delimited | Excel Discussion (Misc queries) | |||
| Converting Excel data into semicolon delimited text file | Excel Discussion (Misc queries) | |||
Linear Mode
