ereast.blogg.se - How to remove line spaces in word with find and replace

The above steps would remove all the line breaks and replace these with a comma.

In the replace field, enter a comma followed by a space character (, ).

You may not see anything, but this puts the line break character in the ‘Find what’ field

Place the cursor in the ‘Find what’ field and use the keyboard shortcut – Control + J (hold the Control key and press the J key).

In the options that show up, click on ‘Replace’.

In the Editing group, click on ‘Find & Select’.

Select the dataset from which you want to remove the line breaks.Suppose you have a dataset of addresses as shown below from which you want to remove the line breaks.īelow are the steps to remove line breaks using Find and Replace and replace it with a comma: You can easily apply this to a large dataset and Find and Replace will do all the heavy lifting by finding all the line breaks and removing them from the cells. The easiest way to remove line breaks manually is by using Find and Replace. Remove Line Breaks Using Find and Replace Remove Line Breaks Using Find and Replace.