Removing unnecessary line breaks after the texts

Hello,

Here's my problem:

---------------------------
Example Text 1
Example Text 2
Example Text 3


---------------------------

I want to remove the line breaks after "Example Text 3" without affecting the line breaks of the texts? Here's what I need:

---------------------------
Example Text 1
Example Text 2
Example Text 3
---------------------------

Thanks in advance!

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

VBA

Please Login or Register  to view this content.

Hi jindon,

Just tried the code and it worked. The problem is, it worked only on column A. How can I do it in the entire sheet?

Thanks in advance,
Oliver

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

hey jindon, you are a rockstar! you saved me a lot of time, thanks a lot mate!

OK, don't forget to mark this thread as "Solved".