How to move texts from Notepad to Column in MS Excel?

This is also known as "Import a Delimited Text File".

Step 1: To import a Delimited Text File, the user has to go to the “DATA” ribbon. In this there is a tool named “Get External Data”. By the help of this tool user can import data from Access, Web or from Text files. The text file has to be delimited.

MS Excel 2013 - Data Ribbon

Step 2: Click “From Text” Option. An Import Text File dialog box will pop in. Locate the delimited file you want to import in excel. Click “Import”.

Post clicking “Import”, you will get a “Text Import Wizard”. It has 3 steps involved in it. Check My Data as headers and click Next.

Click the Delimiters available in your file. In the shown example it is “Tab” delimiter. Then click Next. This will lead to you Step 2 of 3.

Now you have to identify if the data available in the text file is differentiated by Tab or Semicolon or Comma, Space or Others. Pick the right option and click Next. This will lead to you Step 3 of 3.

Step 2 of this Import Wizard provides you option to select each column and set the Data Format. It has and Advanced option as well to convert numeric values to numbers etc. Once done click Finish.

This will lead to another pop up dialog box of "Import Data". This option allows user to view the data in following format:-

1. Table
2. Pivot Table Report
3. Pivot Chart etc.

It also asks where do you want to put the data say which Cell on the existing worksheet or New Worksheet. Locate the cell from where you want the data to come in. Your available data in Delimited Text file will get imported in excel.

For more information on how to do this, please get in touch with me at Samrat.biswaas@gmail.com

Friends, Now Excel in MS Excel is available in Facebook as well. You can quickly raise your MS Excel related queries in its platform. I will try to resolve them.

Visit Other MS Excel Tips and Tricks
How to avoid #DIV/0! and #Value! Error?
How to create One Variable Data Table using What-if-Analysis?

Samrat Biswas, Six Sigma (Green Belt), MOS Excel Expert 2013, ITIL 2011 Foundation
Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), and MS Visio 
---------------------------------------------------------------------------------------------------------
Be a part of regular Weekend Knowledge Sharing Sessions
Reach me @ +91 8095039316/ +91 8095039315
https://www.facebook.com/Samrat.Biswas