Split the Contents of a Cell across Multiple Cells in Excel

Question

How to split the contents of a cell across multiple cells in Excel?

Answer

  1. Select the cell, or entire column, that contains the text values that you want to distribute across other cells. Note A range can be any number of rows tall, but no more than one column wide.  Maintain enough blank columns to the right of the selected column to prevent existing data from being overwritten by the data that will be distributed.
  2. On the Data tab, in the Data Tools group, click Text to Columns.
  3. Follow the instructions in the Convert Text to Columns Wizard to specify how you want to divide the text into columns.

For more information about Microsoft Excel Basics, please view the full tutorial from the CTL here: Excel Part 1

If you need further assistance, please click the CTL Support Request button on this page.

CTL Support Request

Details

Article ID: 7889
Created
Thu 12/22/22 1:18 PM
Modified
Fri 11/3/23 3:43 PM
KCS Article Status
WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance
Validated

Related Services / Offerings (1)

CTL Support Request
The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.