(II) Splitting with "fixed width", which can be split into two or multiple columns(Excel split cell in half vertically)ġ. If the content to be split is mostly one of the symbols, you can select it for splitting symbol.
In addition, there are four kinds of split characters in the "Convert Text to Columns Wizard", which are "Tab, semicolon, comma and space". As can be seen from the split result, the split symbol(-) is not available after splitting, and the same is true if a character is used as a split character. Insert a column between the first column and the second column click A to select column A, select the "Data" tab, and click "Text to Column", open the "Convert Text to Columns Wizard" dialog, select "Delimited", click "Next", check "Other", enter - on the right side of "Other", click "Next", click "Finish", then the first column is split into two columns from the short cross(-) the operation steps are as shown in Figure 3:Ģ. Right-click B at the top of the second column and select Insert from the pop-up menu. If you want to split the "No." column of the clothing table into two columns.
(I) How to split a column into two in excel or how to split one cell into two in excelġ. II, How to split cells in excel(Split content) Hint: Since the cells to be Unmerged lacks a border, it looks like the three cells are still one, but the text has been moved to the cell A3 if you want to add a border to the cells to be unmerged, you can press Ctrl + 1 to open a dialog, select the "Border" tab, click the icon on the outerline, and click "OK". Hint: Excel split cells are not split into a few words like Word can be split, it will only be split according to the number of merged cells, for example, when merging cells is to merge two cells into one cell, then split it is automatically split into two the three cells are combined into one cell, which is automatically split into three when splitting, and so on.Įxcel Unmerge Cells shortcut key is Alt + H + M + U, the operation method is: Select cells B3:C3, hold down Alt key, press H once, press M once, press U, then B3:C3 are Unmerged three cells again, the process steps, as shown in Figure 2: Select the cells to be unmerge, such as A1 and B1, select the "Home" tab, click the black small inverted triangle to the right of "Merge & Center", and select "Unmerge cells" in the pop-up menu, then A1 and B1 are unmerged again the process steps, as shown in Figure 1:
Whether it is splitting the content of cell or splitting the column, you can use the Text to Columns and the formula if the data has obvious separators or even distribution, you can use the Text to Columns if the data is mixed with alphanumeric characters, you cannot use the Text to Columns, you can use the formula. In addition to splitting cells, you often encounter splitting a cell into two or more cells or splitting a column into two or three columns or more in the process of editing an Excel table. You cannot split a single cell that has not been merged into two or more. Excel split cells can only split the merged cells. There are two ways to split a cell in Excel, one with the options provided by Excel and the other with shortcut.