Find and Replace Carriage Return in Excel (with Quick Steps)

In many Excel documents, we face a lot of Carriage Returns in our workbook. However, for some documentation purposes, we try to give up ourselves from Carriage Return. In this blog post, we will find and replace Carriage Return in Excel. So, follow the easiest way to solve your problem which is just a few clicks away.


Download Practice Workbook

You can download the practice workbook from the following download button.


Steps to Find and Replace Carriage Return in Excel

Carriage Return moves some of a cellโ€™s content to new lines into the exact same cell. The terms return, and CR is also used to refer to it.

The sample data set shows some addresses of the people from different states. Due to the import of text files, the Address field has several carriage returns. We will address this issue in this article.

Sample Data: Find and Replace Carriage Return in Excel


๐Ÿ“Œ Step 1: Select Data

  • To begin with, we have to select the column that has a lot of CR or Carriage Return. After selecting the column, we will press Ctrl+H to open up the Find and Replace popup.

Select and Enter Ctrl+H

Read More: How to Find and Replace in Excel Column (6 Ways)


๐Ÿ“Œ Step 2: Go to Find and Replace Dialog Box

  • After pressing Ctrl+H to open up the Find and Replace the image shown below will appear.

Find and Replace popup

Read More: How to Find and Replace Using Formula in Excel (4 Examples)


๐Ÿ“Œ Step 3: Press Ctrl+J to Find Carriage Returns in Data and Replace Them All

  • In the Find What field enter Ctrl+J. Then there will be a blinking dot in the box. After that, we will hit the Replace All button.

Applying Ctrl+J to find and replace carriage return

๐Ÿ’ฌ Note:

You could put a space in the Replace with box too.

  • We have replaced Carriage Return with space and so here is our result which is given below.

Final Result without Carriage Return in data

Read More: How to Find and Replace within Selection in Excel (7 Methods)


Conclusion

The fundamental tasks to Find and Replace Carriage Return in Excel will be completed by this approach and these steps. The workbook is also available for download, so you may use it for your own practice. If you have any questions, problems, or recommendations, just let me know in the comment area.ย Visit our blog ExcelDemy for more similar Excel-related issues.


Related Articles

Al Ikram Amit

Al Ikram Amit

Hi there. I am Amit, completed my study from BUET. Currently, i am working as an Excel & VBA Content Developer at ExcelDemy. Now you can see my articles in ExcelDemy blog.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo