How to split a cell diagonally in Excel?
Split Selected Cells. Suppose you have three items in a cell separated by a comma. In Excel, there is a tool called Text to Columns. This tool will take columns of cells and separate them into multiple adjacent cells based on a delimiter, which you specify. To split the cells in Excel, execute the following steps. For manual, one-off conversions, Excel has a built-in feature called 'Text to Columns' that can split text in cells with a delimiter of your choice. You'll find this feature on the the Data tab of the ribbon in the Data tools section.
You can use the LEFT, MID, RIGHT, SEARCH, and LEN text functions to manipulate strings of text in your data. For example, you can distribute the first, middle, and last names from a single cell into three separate columns. The key to distributing name components with text functions is the position of each character within a text string. The steps to split a cell with Text to Columns are: Select the cells containing the text to be split. From the ribbon, click Data Text to Columns. The Convert Text to Columns Wizard dialog box will open. Select the Delimited option. This allows us to split the text at each occurrence of specific characters.
It’s common to split cell content by space, comma, etc. in Excel. But do you know how to split a cell diagonally as below screenshot shown? This article will show you the solution.
Split a cell diagonally in Excel
Split a cell diagonally in Excel
To split a single cell diagonally in Excel, please do as follows:
1. Right-click the specified cell you will split diagonally, and select Format Cells from the context menu. See screenshot:
2. In the Format Cells dialog box, please click to enable the Border tab, click to highlight button in the Border section, and then click the OK button. See screenshot:
Now the diagonal line is added in the specified cell. See screenshot:
3. Please type the two words in the specified cell as you need. Then highlight the first word in the cell, and click the Arrow at the bottom-right corner of the Font group on the Home tab. See screenshot:
4. In the popping out Format Cells dialog box, please check the Superscript option, and click the OK button. See screenshot:
5. Please repeat above Step 3-4 to format the second word as a subscript.
Now you will see the two words in the specified cell is split diagonally. See screenshot:
Demo: Split a cell diagonally in Excel
Kutools for Excel includes more than 300 handy tools for Excel, free to try without limitation in 30 days. Free Trial Now!Buy Now!
Excel Mac Split Cell Diagonally
Batch Separate text and numbers from one cell/column into different columns/rows
Kutools for Excel enhances its Split Cells utility and supports to batch separate all text characters and numbers of one cell/column into two columns/rows. Full Feature Free Trial 30-day!
Related articles:
The Best Office Productivity Tools
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
- Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
- Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
- Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
- Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
- Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
- Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
- Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
- More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
- To post as a guest, your comment is unpublished.Thanks for the help
Split a Cell | Text to Columns | Flash Fill | Formulas to Split Cells
To split a cell in Excel, add a new column, change the column widths and merge cells. To split the contents of a cell into multiple cells, use the Text to Columns wizard, flash fill or formulas.
Split a Cell
Use the following trick to 'split' a cell in Excel.
1. For example, task B starts at 13:00 and requires 2 hours to complete.
Suppose task B starts at 13:30. We would like to split cell B3 and color the right half.
2. Select column C.
3. Right click, and then click Insert.
Result:
4. The default width of a column is 64 pixels. Change the width of column B and C to 32 pixels.
5. Select cell B1 and cell C1.
6. On the Home tab, in the Alignment group, click the down arrow next to Merge & Center and click Merge Cells.
Result:
7. Repeat steps 5-6 for cell B2 and cell C2 (and cell B4 and cell C4).
8. Change the background color of cell B3 to No Fill.
Result:
Note: suppose task A ends at 15:30. Use the trick explained above to 'split' cell E2. Download the Excel file and give it a try.
Text to Columns
To split the contents of a cell into multiple cells, use the Text to Columns wizard. For example, let's split full names into last and first names.
1. Select the range with full names.
2. On the Data tab, in the Data Tools group, click Text to Columns.
The following dialog box appears.
Excel Split Cell Into Rows
3. Choose Delimited and click Next.
4. Clear all the check boxes under Delimiters except for the Comma and Space check box.
5. Click Finish.
Result:
Note: this example has commas and spaces as delimiters. You may have other delimiters in your data. Experiment by checking and unchecking the different check boxes. You get a live preview of how your data will be separated.
Flash Fill
Do you like Magic? Instead of using the Text to Columns wizard, use flash fill to quickly split data into multiple columns.
1. First, split the contents of one cell into multiple cells.
2. Select cell B1 and press CTRL + E (flash fill shortcut).
3. Select cell C1 and press CTRL + E.
Excel Split Cells In Row
4. Select cell D1 and press CTRL + E.
Note: flash fill in Excel only works when it recognizes a pattern. Download the Excel file and give it a try. Visit our page about Flash Fill to learn more about this great Excel tool.
Formulas to Split Cells
One drawback when using these tools is that the output will not automatically update when the source data changes. Create formulas to overcome this limitation. Let's split full names into first and last names.
Excel For Mac Split Cells Without
1. The formula below returns the first name.
How To Split Excel Cell Into 2
2. The formula below returns the last name.
Excel For Mac Split Cells
3. Select the range B2:C2 and drag it down.
Split Excel Cell In Half
Note: visit our page about separating strings to understand the logic behind these formulas.