Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 Misc

Convert Delimited Text to Columns

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.

Print this tip.

- Subscribe!

Search the Site: