How To Separate Text In Excel Into Two Cells

How to split cells in Excel - How to split 1 cell into 2 cells in Excel. Many times when working with Excel, you need to split 1 cell into 2 diagonal cells to record 2 different data. For those of you who know and do, this is very simple, but for those of you who have never done it, you can rest assured that it is not difficult. Because below I will guide you in extremely detailed steps.

This article, Nguyen Hung will guide you how to split cells in Excel, you can divide 1 cell into 2 cells to enter 2 different data. With this way you can use to split cells in Excel 2003, 2007, 2010 and even Excel 2013. It is very easy so you just read the instructions where to practice always go there.

You can also split merged cells or split a cell into two cells. For ways to merge cells or split cells inHow to split cells in Excel

https://www.youtube.com/watch?v=wt-ih_t9rxw

To split cells in Excel we can only split cells diagonally, and maybe what we need is only possible. To divide cells diagonally in Excel follow the steps below.

If you do not know how to merge cells in Excel, you can refer to the article on how to merge cells in Excel 2007, 2010, 2013 to know how.

Step 1: Select the cell to split, here I will split cell B2 so I select cell B2 then right click and select Format Cells.

Step 2: Format Cells dialog box appears, select the Border tab.

In the Border frame you choose the diagonal style to divide cells accordingly. There are two types of diagonal lines: diagonal up and down diagonal as in the picture. You select then click OK. Alternatively, you can choose the stroke and color of the diagonal.

At this point, cell B2 will be divided into 2 diagonal cells as follows:

Step 3: Now we will see how to enter data into these 2 cross cells. Actually, it is still 1 cell, but we enter data in the following way, it will be displayed as 2 separate cells.

• You select cell B2 then choose Middle align or quickly select by pressing Alt -> H -> AM in turn.
• Enter the data for the diagonal box above as Full Name, then press Alt + Enter to return the line and enter the data for the diagonal cell below as No (ordinal number).
• Then you place the mouse pointer over the letter H and press a space (Space) to adjust the word Full Name to push to the middle of the diagonal above, then stop. Next, you place the mouse pointer over the letter S and press a space (Space) to adjust the letter STT to center the diagonal box below and then Enter is done.

After the alignment is complete you will get 2 diagonal cells with 2 data as shown below:

So you have successfully divided 1 cell into 2 cells in Excel.

With how to split cells in Excel that Nguyen Hung just instructed, we hope to help you with your work. With the above simple steps, you can split 1 cell into 2 cells in Excel.

Soure: Blebees.com

source https://blebees.com/how-to-separate-text-in-excel-into-two-cells/