• Excel Split Cells In Row
• How To Split Excel Cell Into 2
• Split Cells Excel

How to split a cell diagonally in Excel?

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

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. Split A Cell in Excel, also known as Text To Columns and sometimes called as delimit, is used to split the data of a cell. We can spit a cell with different parameters such as Space, Blank, Commas or any other criteria which breaks a cell into 2 or more cells. How to Use “Text to Columns” in Excel Select the cells you want to split by clicking the first cell and dragging down to the last cell in the column. In our example, we’ll split the first and last names listed in column A into two different columns, column B (last name) and column C (first name.) The Best Tech Newsletter Anywhere. Add characters, remove strings, split cells, extract text, trim spaces, convert symbols, change case, count chars and swap text — the tool lets you do all this quickly and accurately. Feel free to use in Excel for Mac as well as in Excel for Windows and Excel on the web. Get it for free Discover 35+ handy options for your Excel text.

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!

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:

• 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.

• 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!

• To post as a guest, your comment is unpublished.
  Thanks for the help

Applicable to: Office 2019, 2016, 2013; 365 or standard

Here’s a question that we have received from a reader who wanted to divide an Excel column vertically:

I am working on a statistical report in Microsoft Excel, using version 365. I just imported a comma separated value file into the A column and now need to split a column cell vertically into two “halves”. Any simple way to get that accomplished? If it helps i am using Windows 10.

Thanks for the good question. For these scenarios i typically use the Text to Column feature, which serves my purpose pretty well.

Sometimes we import significant amount of data directly into a worksheet or into the data Model (Using Power Query and Power Pivot in Excel). Typically, we import so called comma separated value files files (*.csv). When working with csv files, we typically find ourselves in need of vertically dividing or splitting text between different column cells. In today’s post we’ll cover three useful techniques that you will be able to use:

• Text to Columns for delimited files
• Text to Columns with Fixed Width
• Un merging cells

Read further for the full procedure – which applies with minor variations to Microsoft Office versions starting 2010.

Using the Excel delimiter for splitting text

This technique is specially useful when you are working with a worksheet that contains data which is delimited by commas , semi colons, tabs, spaces and so forth.

Excel Split Cells In Row

• Open your Excel and open the database in which the Columns has to be separated.
• If you have data in the next cell, select the cell and right click on it.

• Click on Insert and then go ahead and select Shift Cells Right.

• Now, select the entire column which will need to be separated.
• Click on Data in the ribbon and then go ahead and select Text to Columns.

• Select Delimited and click Next.

• Click on any one of the option in the Delimiters and select Next.
• Say for Example I have selected Space for separation.

• In the Column Data format Select your option if needed. It will be General as Default.
• To select in which cell the separation has to be done, Click on Destination and select the cells.

• After you have done with the selection, click Finish.

Dividing to Columns using Fixed width

• Open your spreadsheet and select the column cell which has to be divided.
• Again make sure no data is available next to the dividing cell.
• In your Excel header menu, click on Data and select Text to Columns.
• Select Fixed width and Click on Next.

• For creating a break line, click on desired position
• For deleting, double click on the break line.
• For moving, click and drag the break line.

• In the Column Data format Select your option if needed. It will be General as Default.
• To select in which cell the separation has to be done, Click on Destination and select the cells.
• Click Finish after selecting your format.

Un merging cells

How To Split Excel Cell Into 2

• To split merged cells, click on Merge & center and select Unmerge cells.

Horizontal split cells in Excel rows

Unlike when working with tables in Microsoft Word, PowerPoint and Outlook; there is no straightforward Split command for achieving horizontal splits in Excel row cells. Readers wanting to horizontal split cells could use specific formulas to divide their table data across two or more table cells in their worksheet.

Split Cells Excel

Hope it helps 🙂