Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 More...Less
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:
Split the content from one cell into two or more cells
Note: Excel for the webdoesn't have the Text to Columns Wizard. Instead, you canSplit text into different columns with functions.
-
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.
-
Go toData > Data Tools > Text to Columns.
-
Select the delimiter or delimiters to define the places where you want to split the cell content, and then selectApply.
See Also
Need more help?
Want more options?
Discover Community
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.