Line Breaks In Excel How To Insert Line Break Quick Easy

What is a Line Break in Excel Cell?

How to Insert Line Break in Excel Cell?

Concatenate Function in excelConcatenate Function In ExcelThe CONCATENATE function in Excel helps the user concatenate or join two or more cell values which may be in the form of characters, strings or numbers.read more.AND functionUse of Alt + Enter Method.

Method #1 – Line Break with Excel Formula (& Function)

Suppose we have the name, phone number, and department name in a column. We want them in a single cell combined, but a line separates all three. The data is as follows:

We want all the three data combined in one column D column and want each data to be separated by a line. We will learn the method of using the AND function in this example. But, first, we need to understand what a CHAR function is. Char function in excelChar Function In ExcelThe character function in Excel, also known as the char function, identifies the character based on the number or integer accepted by the computer language. For example, the number for character “A” is 65, so if we use =char(65), we get A.read more: returns the character specified by our computer, a specific code.

Char(10) returns a line break in the cell.

Method #2 – Line Break with Excel Formula (Concatenate)

In the above example, we used the AND formula to insert a line break in a cell. We will learn to insert a line break in the cell using the CONCATENATE function. But first, what is a CONCATENATE function? The CONCATENATE function joins several strings or numbers, or values into a single string.

Now, we need to wrap the text D column to see all the data in the D column. Select the blank cells opposite to the data in the D column. Click on the “Excel Wrap Text” in the “Alignment” section of the “Home” tab. Now in cell D2, we must write the following formula: Now, press the “Enter” key to see the result. We currently do not see the whole data; we need to expand the row by clicking on the expand row button by hovering our mouse between the two cells, A2 and A3. Now, drag the formula to cell D6. We can see that we have successfully inserted a line break in cells using the AND formula.

We can see that we have successfully inserted a line break in cells using the AND formula.

Also, we know what a CHAR function does, but for our revision, let us look again at what a char function does. The CHAR function returns the character specified by our computer, a specific code.

The CHAR(10) inserts a line break in a cell. Now, have a look at the below data:

We have a house number, street name, locality, and city in columns A, B, C, and D. Like we fill out forms, it is the same. However, we want the combined address in the E column. We will use the CONCATENATE formula and the CHAR function to insert a line break in the cell.

Step #1 – First, we need to wrap the text to see all the data.
Step #2 – Select all the cells parallel to data in the E column.
Step #3 – Now, click on “Wrap text” under the “Alignment” section in the “Home” tab.
Step #4 – In cell E2, we must write the following formula:
Step #5 – When we press the “Enter” key, we can see the following result:
Step #6 – We currently do not see the whole data. We need to expand the row by clicking on the expand row button by hovering our mouse between the two cells, A2 and A3.
Step #7 – Now, we must drag the formula to cell E8 and see the result.

We have successfully inserted a line break using the concatenate excel formulaConcatenate Excel FormulaThe CONCATENATE function in Excel helps the user concatenate or join two or more cell values which may be in the form of characters, strings or numbers.read more.

Method #3 – Line Break in Excel Cell (Conventional way)

We will use the last and the most convenient way of using a line break in a cell while working on data. We need to keep in mind that this method only works in a cell. For the next cell, we need to repeat the process. We cannot copy the same formula to other cells like a formula.

We will try to insert a line break in the sentence “I am a Boy” and insert a line break after every word.

Step #1 – In any cell, double click on the cell or press the F2 button to get in the cell.Step #2 – Write I and press the “Alt + Enter” keys.
Step #3 – We can see that it inserted a line break after I. Now, do this for every word.
Step #4 – Press the “Enter” key and see the result.

We have successfully inserted a line break using the “Alt + Enter” method.

Things to Remember

There are a few things we need to remember in line breaks:

To use AND and CONCATENATE functions, we must wrap text to view the whole data.We must expand the rows after wrapping the text.The CHAR (10) function inserts a line break.The “Alt + Enter” method works in a single cell. However, for it to work in another cell, we must repeat the process.

What is a Line Break in Excel Cell?#

How to Insert Line Break in Excel Cell?#

Method #1 – Line Break with Excel Formula (& Function)#

Method #2 – Line Break with Excel Formula (Concatenate)#

Method #3 – Line Break in Excel Cell (Conventional way)#

Things to Remember#

Recommended Articles#