Show-Me  Academy Menu  |  FAQ  |  About  |  Contact  |  See all the latest video tutorials from Show-Me Academy with our RSS feed

Show me how to convert text to columns in Microsoft Excel 2007

Excel -> Microsoft Excel 2007

Problem: When I paste delimited data into Excel it's not properly aligned into columns.



  1. From within another application (e.g., Notepad), copy a selection of text that will be pasted into Excel (after the text is highlighted, right-click on it and select "Copy" from the context menu)
  2. Open Microsoft Excel 2007
  3. Right-click on a cell and click on the "Paste" option in the context menu
  4. Click on the "Data" tab
  5. On the "Data Tools" section, click on the "Text to Columns" button
  6. On the "Convert Text to Columns Wizard - Step 1 of 3" window, click the "Next" button
  7. On the "Convert Text to Columns Wizard - Step 2 of 3" window, uncheck the "Tab" option
  8. Check other options to see how it changes the data display (as shown in the "Data preview" window)
  9. Click the "Finish" button

Menu  |  FAQ  |  About  |  Contact  |  Terms  |  Privacy  |  RSS
© Copyright 2008 by Show-Me Academy, Inc. - All rights reserved