Learn Microsoft Excel: Smart Paste - gHacks Tech News

Learn Microsoft Excel: Smart Paste

If you want to copy contents from a plain text file, for instance one you have created with Notepad or Notepad++, you may have noticed that contents do not get pasted correctly into the spreadsheet even if you have taken great care of making sure the data is aligned properly in the text document. Ashish Mohta published a little tutorial on his website that explains how you can format text files so that data in them is pasted correctly into Microsoft Excel. The process works with every plain text document regardless of the program it has been created in.

When you normally copy and paste contents into Microsoft Excel they will all be stored in the same cell in the Excel application. That is usually not the desired way of how you want the date to be displayed in Excel. A far better option would be to paste the contents into different cells, especially if the text document used a tablet like structure for the contents as well.

The process is actually very simple. You need to use the TAB key to divide data in the text document. When you paste the contents into Excel, you will notice that Excel will automatically add them to different cells automatically.

learn microsoft excel

Each tap of the TAB button represents a new cell in the Excel spreadsheet and that is all you need to know to paste contents properly into the spreadsheet application. Note that you can press tab at any time to sort data into Excel cells. This is even possible at the beginning of the a line in the text file.

It is also interesting to note that this works in other spreadsheet applications as well. I have tested it in Open Office and it worked exactly as in Microsoft Excel.

We need your help

Advertising revenue is falling fast across the Internet, and independently-run sites like Ghacks are hit hardest by it. The advertising model in its current form is coming to an end, and we have to find other ways to continue operating this site.

We are committed to keeping our content free and independent, which means no paywalls, no sponsored posts, no annoying ad formats or subscription fees.

If you like our content, and would like to help, please consider making a contribution:

Comments

  1. Dotan Cohen said on October 13, 2008 at 2:02 pm
    Reply

    Of course, this works with Open Office as well.

  2. Parthi1010 said on October 13, 2008 at 7:38 pm
    Reply

    Alternate Method to smart Paste is to import the text data in excel.

    1. Save the text file either comma or tab separated data
    2. In MS Excel menu >>DATA>>Import External Data>>Import Data
    3. Chose the file, Click Delimited >> Next
    4. Click TAB & Comma in Delimiters >> Next >> Finish

    Thats it …..

Leave a Reply

Check the box to consent to your data being stored in line with the guidelines set out in our privacy policy

Please note that your comment may not appear immediately after you post it.