This tutorial demonstrates trick to merge narration / remarks in Bank Statement running into multiple lines into single line, using various Excel functions like CONCAT, XLOOKUP, ISNUMBER. The trick can be applied to Bank Statements converted from PDF into Excel, where-in decoding algorith is not able to detect multi line narrations, converting it into separate row.
![](https://i.ytimg.com/vi/7av_riLnZNw/maxresdefault.jpg)