In this article we will learn how to import the text file in Excel file and how to export file into text file.
Text import feature is used, when we have to import a text file to Microsoft Excel 2010 & 2013. Examine the text import to ensure that the data which we want to be in that way is imported into Excel.
Let’s take an example & understand how to use the Text Import Utility
We are having an Excel sheet in which we want to import text files, follow below mentioned steps:-
Note: After importing the text file into Excel file date will be displayed in number format. We have to covert the numbers into date format. Select the date range and press the key Ctrl+Shift+3 on your keyboard.
Another way is also available to import the text data in Microsoft Excel.
To Export Excel File into Text File follow below mentioned steps:-
This is the way to convert the Excel file into Text file and Text file into Excel.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.