What are the main features of the text file:
To create text files are small and simple
Text files are not vulnerable to viruses
Import text files such as Excel for further manipulation is easily achievable.
How are text files created? Text files are usually created by users in Notepad. One could, for example, a file with the following structure:
Name Salary
Harry, 5000
Jack, 7000
Husain, 6000
When you import this fileExcel would look like this:
Name Salary
Harry 5000
Jack 7000
Husain 6000
The data in Excel would be in different cells of the table with the "name" and "salary" as the header. Now, this would bring salaries in total, or average, maximum and minimum content by using the appropriate Excel functions for the calculation. Of course you can format the data according to your wishes.
The text in the data files can be separated by a "tab" or even hisCharacter.
As a text file or comma-separated values (CSV) for import into Excel:
In Excel, click on "data" in the menu bar
Select Import External Data "and then" Import data … "
In the Choose Data Source "you will find your text file
Imagine that was in our case, the text of the name "_excel.txt import files" and the desktop "" stored
Then follow the instructions step by step process, as shown in full training videoin the link in the dialog resources.
Of course, the files from a database like MS Access, MS SQL, MySQL, Oracle, etc. can be easily imported. I mentioned in the next article.
In many areas, such as stocks or stock trading, tracking information of visitors to a web site and other data will be treated with "appropriate common" people as a text file and after importing into Excel.
A link to the video training Excel is lower.
Until the next article – Take care!
Related : Inventions ideas Insurance Company Transportation Company Inventions ideas Packaging Company

