Previously we told you how to import Text from any external Text file into the Excel Spreadsheet in MS Excel 2007. (Refer Article Importing Text in Excel07). Now in this article we will tell you how to import Text into MS Excel 2010. Follow these simple steps and you should be done with achieving this Task.
1) Open the Excel spreadsheet where you have to import the Text into. Then got to the Data Tab and under the Data Tab, click on the “From Text” option. See Figure 1 for details.
2) Now you select the file that you want to import into excel spreadsheet. See figure 2 for details.