The best use case is for names, but it’ll come in handy for lots of other surprising things the more you use Excel.

  1. Open Excel and start a new Blank workbook.
  2. Add entries to the first column and select them all.
  3. Choose the Data tab atop the ribbon.
  4. Select Text to Columns.
  5. Ensure Delimited is selected and click Next.
  6. Clear each box in the Delimiters section and instead choose Comma and Space.
  7. Click Finish.

Microsoft Excel Tips

Previous TipNext Tip

Use VLOOKUP in ExcelBack Up Files Automatically in ExcelRemove Duplicate Data in ExcelCreate a Waterfall Chart in ExcelLock Cells in ExcelFreeze Rows and Columns in ExcelBuild a Forecast Chart in ExcelCreate a Funnel Chart in ExcelMake a Treemap in ExcelConvert Excel Sheets to Google SheetsOpen Google Sheets in ExcelCombine Data from Different CellsMerge Cells to Span Multiple ColumnsUse AutoFill for Repetitive DataCopy and Paste Repetitive Data the Easy WayUse Text to ColumnsDraw Diagonal Line in a CellCreate a New Shortcut MenuTranspose Columns Using Paste Special