ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Saving Excel as Text (Tab delmited) (https://www.excelbanter.com/excel-discussion-misc-queries/229528-saving-excel-text-tab-delmited.html)

tcmh

Saving Excel as Text (Tab delmited)
 
I try to save a file with text and I get the following message: file.xtx may
contain features that are not campatible with Text (Tab delimited). Do you
want to keep the workbook in this format? To keep this format, which leaves
out any incompatible features, click Yes. Below is my test sample:

Tim Smith Founder XYZ
Jeff Smith President XYYZD

I have the deleted the other work sheets in the workbook.

Dave Peterson

Saving Excel as Text (Tab delmited)
 
You can ignore the message.

It means that any formulas/formatting/headers/filters/... all that excel stuff
will be lost.

So if you have those kinds of things that you want to keep, make sure you save
it as a normal workbook before (or after) you save the file as a tab delimited
file.



tcmh wrote:

I try to save a file with text and I get the following message: file.xtx may
contain features that are not campatible with Text (Tab delimited). Do you
want to keep the workbook in this format? To keep this format, which leaves
out any incompatible features, click Yes. Below is my test sample:

Tim Smith Founder XYZ
Jeff Smith President XYYZD

I have the deleted the other work sheets in the workbook.


--

Dave Peterson


All times are GMT +1. The time now is 12:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com