Want Bank Description in single cell

Hello Members,

In this excel sheet, bank statement description are in two or more lines.

can we adjust bank description in a single cell.

Thanks

J6:

Formula:

Please Login or Register  to view this content.

Copy and paste into other cells in column J as needed. The IFERROR handles the bottommost record in the range, where instead of finding the next nonblank cell in column A it finds the last nonblank cell in column D.

Hello,

The description which occupies one row will be coming exactly.

But description in two or more rows will be given inappropriate results.

Please solve this issue

Kind & Regards