3 Tips to Batch Remove Carriage Returns (Line Breaks) in Excel

Date:2020-4-27 Author:Olivia

The Excel sheet you copy from a webpage or receive from others might already contains some carriage returns (line breaks), which have no severe impact on the content but do affect the layout, and can cause search error when the phrases are separated. Here I’d like to share 3 tips to help you removing all the carriage returns (line breaks) at once in Microsoft Excel.

The worksheet below contains a lot of carriage returns (aka line breaks) as you can see. I’ll take it as an example.

3 Tips to Batch Remove Carriage Returns (Line Breaks) in Excel

Method 1: Find and Replace

1. Press [Ctrl+H], the Find and Replace dialog box will pop up.

2. Go to Replace tab and select the box of Find what, press (not enter)
[Ctrl
+J] and leave the box of Replace with blank.

3. Simply click Replace All at the bottom left corner.

4. Now all the carriage returns (line breaks) shall have been removed in batch.

3 Tips to Batch Remove Carriage Returns (Line Breaks) in Excel

3 Tips to Batch Remove Carriage Returns (Line Breaks) in Excel

Method 2: Wrap Text

1. Select the whole worksheet which you want to modify.

2. Go to Home tab and click Wrap Text in Alignment group.

3. Now all the carriage returns (line breaks) should have been removed.

3 Tips to Batch Remove Carriage Returns (Line Breaks) in Excel

3 Tips to Batch Remove Carriage Returns (Line Breaks) in Excel

Method 3: Clear Formats

1. Select the whole worksheet which you want to modify.

2. Go to Home tab and click Clear in Editing group.

3. Select Clear Formats in the drop-down list.

4. All the carriage returns (line breaks) in the selected range will be removed immediately.

3 Tips to Batch Remove Carriage Returns (Line Breaks) in Excel

3 Tips to Batch Remove Carriage Returns (Line Breaks) in Excel

Note: you will find the final result of these 3 tips are a little bit different, and the main differences are line spacing and text centered or not. Choose what works better for you and adjust details further – like alternating colors.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

3 responses to “3 Tips to Batch Remove Carriage Returns (Line Breaks) in Excel”

  1. Pretty! This was an extremely wonderful article.
    Thank you for providing this info.

  2. I cannot thank you enough for the blog post.Much thanks again. Awesome.

Leave a Reply to Olivia Cancel reply

Your email address will not be published. Required fields are marked *