Carriage Return in Excel

Updated on April 3, 2024
Article byWallstreetmojo Team
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

What is Carriage Return in Excel Cell?

Carriage return in Excel cell is the activity used to push some of the cell’s content to the new line within the same cell. For example, when combining multiple cell data into one cell, we may want to push some content to the next line to make it look neat and organized.

For example, suppose you have a dataset with different subjects in different columns, and we need to combine those in a single cell in Excel. Here, the carriage return in the Excel method may help you add a line break within a single cell without using multiple lines of cells. In addition, it can also push some text to the next line in the same cell and allows data to have a competent look.

How to Insert a Carriage Return in Excel?

You can download this Carriage Return Excel Template here – Carriage Return Excel Template

So, we can say, “a line breaker or newline inserted within the same cell to push some of the contents of the next line.”

We must follow the steps to insert carriage return in Excel.

  1. For example, let us look at the below data set.

    Excel Carriage Return - Example 1
    We have three sentences in cell A1, separating each by a comma (,). So, in this case, we need to push the second line to the next line and the third line to the next line, like the one below.

  2. As you can see above, it has reduced the row’s width and increased its height by placing a carriage return character.

    Excel Carriage Return - Example 1-1

  3. Ok, let’s get back to this and see how we can insert a carriage return. First, our data looks like this in a cell.

    Excel Carriage Return - Example 1-2

  4. We will place a cursor before the content, which we must push to the next line.

    Excel Carriage Return - Example 1-3

  5. We will press the excel shortcut key ALT + ENTER to insert the carriage return character in the Excel cell.

    Excel Carriage Return - Example 1-4

    Pressing the “ALT + ENTER” key pushes the content in front of the selected data to the new line by inserting a carriage return.

  6. Now again, place a cursor in front of the third-line data.

    Excel Carriage Return - Example 1-5

  7. Next again, we will press the shortcut key ALT + ENTER.

    Excel Carriage Return - Example 1-6

It has inserted the carriage return character to push the data to the new line within the same cell.

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

Insert Excel Carriage Return by using Formula

In the case of concatenating values of different cells, we may need to push a couple of data to the next line.

  • For example, let us look at the below data
Example 1
  • We need to combine these cell values from the above data. But we also need each cell value to be in a new line like the one below.
Example 1-7

Since we are dealing with more than one cell, it is a tough task to keep pressing the shortcut key all the time. So instead, we can use the character function “CHAR” to insert a carriage return.

  • Apply the below formula as shown below.
Example 1-8
  • After applying the formula, we could see the flat row. But, we need to make one small adjustment, i.e., to wrap the formula used cells.
Example 1-9

In this example, we have used the “CHAR(10)” function, which inserts the “carriage return” character wherever we have applied it.

How to Remove Carriage Return Character from Excel Cell?

If inserting the carriage return is the one skill, removing those carriage return characters is another set of skills we need to learn.

  • Assume we have got the below data from the web.
Example 1-10

We can remove the carriage return character from an Excel cell using several methods. The first method is by using the replace method.

  • Select the data range and press the “Ctrl + H” shortcut key.
Example 1-11
  • We need first to find the value we are replacing. In this case, we see the “carriage return” character. To insert this character, we need to press “Ctrl + J.”
Example 1-12

We need to remove the carriage return character so leave the “Replace with” part of this “Find and Replace” method.

  • Now, we will press the button “Replace All,” and it will remove all carriage return characters.
Example 1-13
  • Another way of removing the carriage return character is by using a formula. Below is the formula to remove the carriage return character from the Excel cell.
Example 1-14

Things to Remember

This article is a guide to Carriage Return in Excel. Here, we learn how to insert carriage return in Excel cell by using formula with examples and a downloadable Excel template. You may learn more about Excel from the following articles: –