Generally if you paste data from Notepad to the Excel it will appear only in the cell you selected it. How about if you have some case that you have to get data from excel and you want to paste it in each columns (text appear in first column and some in second and so on).
For example you have data such us below:
And you want the paste result like the sample below:
Ok, Follow the instruction below:
1. Open Microsoft Excel 2007, in the ribbon Menu choose Tab Data-> From Text
2. Click Next
3. In the Data preview, you can add or remove the line it will make separate column in excel
- Add Line -> Click to the Data Preview area
- Remove Line- Double Click the line in the Data Preview area
4. Click Finish
5. Done
Related Topics:
How to configure Word, Excel 2007 options to save file into 97-2003 format?
How to Hide and Protect Pattern / Formula in Microsoft Excel 2007
How to Paste your data from Notepad to the Excel Columns
How to change Text color in the cell that contains negative numbers in Excel 2007
Easy way to copy one cell to a lot of cells in Excel
Easy tips to delete blank rows in Excel
Microsoft Excel 2007: How to take limit value to the cell
Thanks for the 'how to' -- you're a genius
ReplyDelete