Summary: Easily convert text copied from another program to columns in an Excel 2003 spreadsheet.
When copying data from external sources to a Microsoft Excel 2003 spreadsheet, you may have come across data delimited by commas, spaces, tabs, or other characters. Instead of copying each piece of data to a separate column cell, you can instead paste in the entire series of data and have Microsoft Excel move the data to separate columns. To do so:
1. Paste the series of data into a cell, i.e.:
1,5,9,2,11
54.23 23.11
-93.49 88.42
2. Select the cell.
3. Choose "Data" - "Text to Columns".
4. Follow the on-screen prompts in the wizard to determine the delimiter character, column size, and other characteristics. When complete, your data will be split up into multiple columns.
Add: Del.icio.us |
Digg |
Furl |
My Yahoo!
Last Modified on: July 13, 2008, at 12:04 A.M. EDT
Return to the Microsoft Excel 2003 Misc page.
Search the Site: