Removing multiple line breaks into single line break

Hi,
I have attached and Excel file. In comments column can those giant spaces between paragraphs be made to just one space? Snapshot is attached.

Thanks and Regards,

Line Breaks Snapshot.png

There might be vertical bars in the text. Actually, using [Ctrl]+F and using Find All, B178, B200 and B212 each contain vertical bars. Safer to use non-glyph characters, e.g., CHAR(8) or CHAR(127).

Next, there are no CHAR(13) not followed by CHAR(10) in B2:B244.

Standard approach when there's something like TRIM,

Formula:

Please Login or Register  to view this content.

That assumes there should be no empty text lines between paragraphs. If there should be an empty line between paragraphs,

Formula:

Please Login or Register  to view this content.

To be honest, this is something Google Sheets handles so much better than Excel that it may be worthwhile to perform this edit in Google Sheets. Here's a link to a copy of the OP's file in Google Drive. The cells in B2:B244 are modified as needed in D2:D244. The formula I used is a far more compact

Formula:

Please Login or Register  to view this content.

I appreciate your effort and it works but the multiple line breaks should be substituted with Two Line Breaks so that we could see the space atleast. In your solution it has completely removed the space. I hope you understand my concern.

Thanks and regards.

Did you try my 2nd formula?

Thank you so much everybody for helping me out. I am satisfied completely