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

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