Erase unnecessary Line Breaks in the cells

Hi

Like it says in the topic title , I want to erase all line breaks which I am not using from my work sheet. But still keeping the line breaks which has something written to it.

Since my English isn't good please think this as a example of one cell.

-------------------------------------------
- Example text number 1
- Example text number 2
- Example text number 3
- Example text number 4
- Example text number 5
---------------------------------------------

Using "Find & Replace" I got to replace the ones I want to erase with nothing, so its blank. Too bad the Excel doesn't replace the line breaks with it, so this is what I get.

-------------------------------------------
- Example text number 1
- Example text number 2

- Example text number 4

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

The result which I want to have is:

-------------------------------------------
- Example text number 1
- Example text number 2
- Example text number 4
---------------------------------------------

I know about the Clean Function but that function eases all the line breaks from the cell, which I dont want to.

So my question is can the excel do this?
If not that whould mean that I have to delete the line breaks by hand for hundreds of cells.

Sincerely
artner

Thank you sglife

With out this I would have spent an hour or even more deleting one line break after another.

Your first code was easy to understand too. I just didn't know that I could insert line breaks in the code too.

Sincerely
artner

Hi,

I am trying to erase blank line breaks by following the above tread but it seems that it is not working for me

My cell looks like the below

Comment 1





Comment 2
Comment 3



Comment 4




Now I want the result to exclude the line breaks and show as below

Comment 1
Comment 2
Comment 3
Comment 4

Please help

Sorry Admin, I didn't realize it yesterday. Will take care from next time.

Thanks a lot!