Wednesday, March 21, 2012

How to Delineate Commas in Excel


1. Open Microsoft Excel and open the comma-separated list in another program such as Notepad.
2. Click and drag with the mouse pointer to highlight each item in the comma-separated list. Right-click the list and then click 'Copy' to copy the list to the Windows clipboard.
3. Click cell A1 in the upper left corner of the Excel spreadsheet. Right-click the cell and then click 'Paste' to paste the list from the Windows clipboard into Excel.
4. Click the 'Data' tab at the top of the Excel window.
5. Click to highlight column 'A' of the spreadsheet and then click the 'Text to Columns' button in the 'Data Tools' section of the toolbar.
6. Click the 'Delimited' radio button at the top of the window and then click 'Next.'
7. Click the 'Comma' check box under 'Delimiters' and remove any other checks.
8. Click the 'Finish' button.

Blogger news