Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

You might want to split a cell into two smaller cells within a single column. Unfortunately, you can’t do this in Excel. Instead, create a new column next to the column that has the cell you want to split and then split the cell. You can also split the contents of a cell into multiple adjacent cells.

See the following screenshots for an example:

Cells in Excel Cells that have been split

Split the content from one cell into two or more cells

Note:  Excel for the web doesn't have the Text to Columns Wizard. Instead, you can Split text into different columns with functions.

  1. Select the cell or cells whose contents you want to split.

    Important: When you split the contents, they will overwrite the contents in the next cell to the right, so make sure to have empty space there.

  2. Go to Data > Data Tools > Text to Columns.

  3. Select the delimiter or delimiters to define the places where you want to split the cell content, and then select Apply.

See Also

Merge and unmerge cells

Merging and splitting cells or data

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!