place the cursor after the last letter of paragraph after which annoying gap exists.On the keyboard, press Ctrl + H to open the Find and Replace dialog box, with the Replace tab active.Д¬lick anywhere on the page that has the gapвЂ¦.This gap is due to section break.Select the cells that you want to search.How do you find and replace a line break? Click on the вЂњReplace allвЂќ button, and then press Ok.Press Space bar in the Find What field and make sure the вЂњReplace withвЂќ field is empty.Press Ctrl + H to open the вЂњFind & ReplaceвЂќ dialog box.Press Ctrl + Space to select all cells in a column.If you have imported or copied data from Web pages you may not be able to remove the extra spaces with the TRIM() function if they are created by non-breaking spaces. One space character commonly used in Web pages that TRIM() will not remove is the non-breaking space. Press the Replace All button and enjoy the result!.In the Replace With field, enter any value to replace carriage returns.Press Ctrl+H to open the Find & Replace dialog box.Select all cells where you want to remove or replace carriage returns.17 kg, AD 565, 2:50 pm ) How do I get rid of a second line in an Excel cell? It is advisable to use a non-breaking space (also known as a hard space) to prevent the end-of-line displacement of elements that would be awkward at the beginning of a new line: in expressions in which figures and abbreviations (or symbols) are separated by a space (e.g. Double-click the cell in which you want to insert a line break. To start a new line of text or add spacing between lines or paragraphs of text in a worksheet cell, press Alt+Enter to insert a line break. How do I make a new line in an Excel cell? In financial analysis, the TRIM function can be useful in removing irregular spacing from data imported from other applications. TRIM helps remove the extra spaces in data and thus clean up the cells in the worksheet. The TRIM function is categorized under Excel Text functions. Non-breaking spaces keep two words on the same line, regardless of the width of the screen in Microsoft Word or HTML. What is a non-breaking space in Microsoft Word?

Non breaking space word 2011