This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2003 Misc - Convert Delimited Text to Columns

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.



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Misc - Convert Delimited Text to Columns.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.