EDUCBA

EDUCBA

MENUMENU
  • Blog
  • All Courses
  • All in One Bundle
  • Login
Home Excel Excel Resources Excel Tips Carriage Return in Excel

Carriage Return in Excel

Madhuri Thakur
Article byMadhuri Thakur

Updated June 8, 2023

Carriage Return in Excel

What is Carriage Return in Excel?

The carriage return is a method in Excel that helps you add a line break within a single cell to add text as multiple lines within a single cell without consuming multiple lines of cells. We have carriage returns that can help us in such situations and eventually save us. Using the formula, This article will show how a carriage return can be inserted within the cell. It is one way to push some text into the next line (it breaks the line) in the same cell, which allows your data to have a decent view.

Examples of Carriage Return in Excel

In Excel, Carriage Returns allows you to wrap text within a cell or a merged set of cells. Let’s look at a few examples.

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

Suppose we have text data as shown below in cell A1 of the Excel sheet.

example 1-1

However, it seems lengthy and doesn’t look good. We wanted it to look like the one in the screenshot below:

example 1-2

For adding line breaks at the specific position within the text. We can add the carriage return within the text using the formula or the Alt + Enter keys on the keyboard.

We will see these two ways of adding carriage return inside a text within Excel. Let’s understand how to Insert the Carriage Return in Excel.

Example #1 – Insert Carriage Return using Keyboard Shortcuts

Suppose we have data as shown below in cell A1 of the worksheet. Where multiple lines are included within the same cell, and each line is separated with a comma.

Examples  1

Step 1: Press the F2 key to take the cell into edit mode and place the cursor at the place from where you wanted to break the line or the place after which you wanted the data to push on a new line.

Example  2

Step 2: Hold the Alt key and press the Enter key to break the line at the point where we have placed the cursor.

Example 3

Step 3: Now, again, place a cursor at the place where you wanted a line, a break, and the content to be moved to the next line. In this case, place a cursor before NY, or you can say after the second comma.

Example 4

Step 4: Repeat Step no 2 to add a line break or carriage return after the second comma. The text now should look like the one below:

Carriage Return in Excel 5

This is the simplest way to add the carriage return/line breaks within a cell inside Excel.

Example #2 – Insert Carriage Return in Excel using a Formula

Suppose we have data as shown below, where we have different fields stored in different columns, and we need to combine those in a single cell but with carriage return/line break.

Insert Carriage Return in Excel 2-1

We must use the concatenate operator to combine the data from different cells. However, adding the line breaks using the Alt + Enter method does not make sense when we use a formula to combine the cells. Therefore, we will use the CHAR function, which allows you to add special characters within the cells. Let’s see how this all goes in Excel.

Step 1: We all know how to concatenate the cells in Excel. Use concatenate operator (“&”) to concatenate the cells A2:D2 in cell E2.

Insert Carriage Return in Excel 2-2

If you press enter to see how the cells are combined, you can see no spacing after each cell value. We can add this using a concatenate operator under the same formula in cell E2.

Insert Carriage Return in Excel 2-3

Step 2: Use “”(single space) to add spacing after each cell value and use concatenate operator to combine it with the current formula combination under cell E2.

Insert Carriage Return in Excel 2-4

Step 3: Now, we must add the carriage returns after each cell value (i.e., after A2, B2, and C2). Use CHAR(10) under the previous formula and connect it with the old one after each cell using the concatenate operator.

Carriage Return in Excel 2-5

The formula CHAR(10) allows the system to add the carriage return in the text. Numeric value 10 specifies the line break/carriage return in Excel.

Step 4: Now, select cell E2 and click on Wrap Text present under the Alignment group under the Home tab to make that layout as we expect.

Carriage Return in Excel 2-6

We can add the carriage return under Excel using a keyboard shortcut and a Formula. Now, we will see how to remove Carriage Return from the cells.

Example #3 – How to Remove Carriage Return

If you are using Alt + Enter to add carriage return within a cell, you can remove those by using Excel Find and Replace tool.

  • Select a cell within which you have carriage return/line break and Press Ctrl + H to open up Excel Find & Replace window.

Remove Carriage Return 3-1

  • Under “Find What:” Press Ctrl + J from your keyboard to find the line break or carriage return present under the cell.

Remove Carriage Return 3-2

  • Under “Replace with:“, you don’t need to do anything. Just hit the replace all button.

You can see the carriage return has been removed from the text.

Remove Carriage Return 3-3

If you have used a formula to insert carriage return within a cell, you can use two formulas to remove the same.

  • In cell E4, use the formula as =TRIM(E2) to remove the carriage return from cell E2.

Remove Carriage Return 3-4

You can also use Excel’s substitute function to remove carriage returns from a formulated cell.

  • In cell E5, use formula as =SUBSTITUTE(E2,CHAR(10), “”). This formula removes carriage return from cell E2.

Remove Carriage Return 3-5

This is it from this article, where we have seen how to add the carriage returns/line breaks in a text and various ways to remove carriage returns from a cell. Let’s wrap things up with some points to be remembered.

Things to Remember

  • Carriage Return allows you to add the line break within a single cell.
  • The formula CHAR(10) allows you to add the carriage return within a cell. Numeric value 10 in Excel specifies the carriage return/line break.
  • We can use Excel’s TRIM or SUBSTITUTE function to remove carriage returns from a cell.

Recommended Articles

This is a guide to Carriage Return in Excel. Here we discuss How to Insert Carriage Returns in Excel, practical examples, and a downloadable Excel template. You can also go through our other suggested articles –

  1. Trunc in Excel
  2. SUBSTITUTE Function in Excel
  3. Concatenate Strings in Excel
  4. TRIM Formula in Excel
MICROSOFT POWER BI Course Bundle - 8 Courses in 1
34+ Hours of HD Videos
8 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
MS Excel & VBA for Data Science Course Bundle - 24 Courses in 1 | 10 Mock Tests
87+ Hours of HD Videos
24 Courses
10 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
All-in-One Financial Analyst Masters Training Program Bundle - 550+ Courses | 300+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.9
All-in-One Data Science Bundle - 400+ Courses | 550+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.7
Primary Sidebar
Popular Course in this category
MS Excel Course Bundle - 36 Courses in 1 | 13 Mock Tests
 137+ Hours of HD Videos
36 Courses
13 Mock Tests & Quizzes
  Verifiable Certificate of Completion
  Lifetime Access
4.9
Price

View Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

Download Carriage Return Excel Template

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Carriage Return Excel Template

EDUCBA

डाउनलोड Carriage Return Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more