Tweet
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 data to be converted 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.
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 data to be converted 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.
Comment