We Value Your Privacy

We and our partners use technology such as cookies on our site to personalise content and ads, provide social media features, and analyse our traffic. Click below to consent to the use of this technology across the web. You can change your mind and change your consent choices at anytime by returning to this site.

Update Consent
Loading ...

How to Delineate Commas in Excel

Updated July 19, 2017

If you receive a list of items separated by commas, you can use Microsoft Excel to make the list easier to read and far more organised. Excel has the ability to use the commas to delineate the columns in a spreadsheet, placing each item on the list in its own cell. In addition to making the information on the list simpler to digest, this also allows you to manipulate the data by changing the sort order and creating charts.

Loading ...
  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.

Loading ...

Things You'll Need

  • Microsoft Excel 2007 or 2010

About the Author

Jason Artman has been a technical writer since entering the field in 1999 while attending Michigan State University. Artman has published numerous articles for various websites, covering a diverse array of computer-related topics including hardware, software, games and gadgets.

Loading ...