Generate a TAB When Converting From Excel to Delimited Text

C

ConfusedNHouston

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
 

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

Similar Threads

How can I convert tab delimited files to pipe delimited? 2
Tab delimited text file import on double click 2
Download/Import from Tab Delimited - Formatting of Data 5
Excel adding unwanted tabs to text delimited files 1
Double quotes when exporting to tab delimited file 2
Converting excel file to tab delimited (txt) file 1
Losing Tab Delimited info in excel 1
VBA to break out worksheets from a workbook 2

Top