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

Date:2019-9-10 Author:Olivia

The worksheet you copy from a webpage or get from your colleague might already contains some carriage returns (line breaks). They may not have a real impact on the content, but if you pay no attention to them, the whole sheet will look disorganized and could cause search error when the phrases are separated. Here I’d like to give 3 tips to batch remove carriage returns (line breaks) in Microsoft Excel, feel free to pick the one suites you better:

The worksheet below contains a lot carriage returns (line breaks) as you can see.

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

Tip 1: Find and Replace

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

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

3. Simply click Replace All at bottom left.

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

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

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

Tip 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) have been removed in batches.

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

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

Tip 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. Now all the carriage returns (line breaks) have been removed in batches.

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

3 Tips to Batch Remove Carriage Returns (Line Breaks) in Microsoft 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.

Leave a Reply

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