Export to Text function is used to export data into text file(s).
The following guidelines describe how Export to Text is used.
Select the data that needs to be exported. There are two ways by which you can select the data: 1)By manually selecting the data from the sheet. 2)By entering the cell indices of the starting and ending block, for example $A$1:$I$800.
You can select Change sheet if you want to select data from some other sheet. Also, click on the My data has headers checkbox if you have selected the headers with the data.
After selecting the data, click on OK.
If the data need to be exported to multiple text files, check Partition the data box and follow the steps in Case 2.
Under Column Specifications, preview of the data to be exported will be displayed. The columns can be reordered by selecting a column and drag it across the table. Each column contains a checkbox next to it. All the column to be exported should be checked.
You will be asked where to save the result. To write the result in the Existing WorkSheet, you can input the index of the starting cell where you want to write the result. Or you can write the result in a New Worksheet.
The figure displays the open text file into which data was exported. The data in the text file is ","(comma) separated and contain headers.
Repeat the steps step 1 to step 3 in Case 1.
After specifying the details for partition, continue from step 5 in Case 1. The result is shown in figure below:
The result shows a list of files corresponding to each Company. The open text file shows the file corresponding to one company with ","(comma) separated data.