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