Removing unnecessary line breaks after the texts

You could try using Find& Replace (CTRL-H) and in the Find What box hold down the Alt key and type 010 on the numeric keypad (do this twice), leave the Replace box empty, then click Replace All.

It worked for me in a test sample.

Hope this helps.

Pete

Hello Pete,

Thanks for your answer. Sorry I wasn't able to tell that the number of trailing line breaks differs from one cell to another. Some cells have only 1 line break, some has 3, some has 5. Is there a quick way to remove all of them using a code?

- Oliver

The procedure I gave you is to remove pairs of line breaks, so you might have to do it twice if you have an odd number to start with.

The ASCII code is 10 for those line breaks, so you could use a formula with CHAR(10) and SUBSTITUTE, but Find & Replace is quicker.

Hope this helps.

Pete